# Oracle Fusion Receivables: Import AutoInvoice rejects lines

> Source: https://netray.co/erp-help/fusion-receivables-autoinvoice-import-rejected-lines
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

Import AutoInvoice validates each interface line against transaction sources, types, customers, terms, accounting rules and tax, then writes failures to an error table instead of creating the transaction. Open the AutoInvoice exceptions for the batch, fix the data on the interface lines or the setup behind it, and resubmit the import.

## Kind

error

## System

oracle-fusion

## Erp

Oracle Fusion Cloud ERP

## Module

Receivables / AutoInvoice

## Query

Oracle Fusion Receivables AutoInvoice lines rejected how to find and fix errors

## Alternate Queries

- Import AutoInvoice errors Fusion
- RA_INTERFACE_ERRORS_ALL Fusion Cloud
- Fusion AutoInvoice invalid transaction type batch source
- Manage AutoInvoice Exceptions Fusion

## Applies To

Oracle Fusion Cloud Receivables, including billing integrations from SCM and external systems

## Steps

### Find and clear rejected lines

**Items:**

- Run Receivables > Billing > Import AutoInvoice (or review the scheduled run) and open the output of the Import AutoInvoice process.
- Open the Import AutoInvoice Execution Report and note the batch source, the number of lines rejected and the error messages.
- Use the Manage AutoInvoice Exceptions task to see each rejected line with its message and the interface line attributes.
- Correct the value in place when the task allows editing, or correct the source data and reload through FBDI or the feeding integration.
- Check the batch source in Manage Transaction Sources: invoice numbering, allowed transaction types and whether validation of reference fields is on.
- Confirm the transaction type, payment terms, bill-to customer account and site, and revenue accounting rule exist and are active for the business unit.
- Resubmit Import AutoInvoice for the same batch source and batch name, then verify the created transactions in Manage Transactions.

## Sections

### What AutoInvoice does with each line

**Body:**

AutoInvoice reads rows from the interface tables, chiefly RA_INTERFACE_LINES_ALL, with distributions and sales credits in their companion tables. It groups lines into transactions using the grouping rule on the batch source, validates each reference, derives defaults and creates the invoice, credit memo or debit memo. A line that fails any validation is not created; the error is written to RA_INTERFACE_ERRORS_ALL with a message and the offending column.

Because the whole transaction is grouped, one bad line can reject the other lines that share its grouping attributes. That is why a single missing account on line three can make a ten-line invoice disappear. The execution report counts rejected lines, but the business impact is whole invoices not billed.

### The usual causes

**Body:**

Transaction source and type. The batch source named on the interface line must exist in the business unit, and the transaction type must be valid for that source. A typo in the source name or a type that is inactive produces an invalid reference message.

Customer and site. The bill-to account or site number must exist and be active, and the bill-to site must be usable for the business unit. Integrations that pass the customer by number when the target expects an internal identifier are a recurrent trap.

Accounting. When revenue accounts are not supplied, AutoInvoice derives them from AutoAccounting rules. If a rule cannot derive a segment, or the resulting combination fails cross-validation, the line is rejected. Missing or end-dated accounting rules for deferred revenue have the same effect.

Terms, currency and rates. Payment terms must be active, and a foreign currency invoice needs a conversion rate for the transaction date and rate type. Missing daily rates are often only noticed at month end.

Tax. If tax determinants are missing, tax line creation fails even though the invoice lines are fine.

### Reading the interface tables directly

**Body:**

When the exceptions screen is not enough, query the interface tables through a BI Publisher data model or the supported reporting path your environment allows. Join errors to lines on the interface line ID and group by message text to see which error dominates. Direct database access is generally not available in Fusion, so use reports and the exceptions task rather than expecting SQL*Plus.

Most volume problems are systemic: one upstream system sending a retired transaction type, or one new business unit with no transaction source defined. Grouping rejects by message and batch source usually points to the setup gap in a few minutes.

**Code:**

-- BI Publisher data model sketch (names indicative, verify in your pod)
SELECT l.interface_line_attribute1, e.message_text, COUNT(*)
FROM ra_interface_lines_all l
JOIN ra_interface_errors_all e
  ON e.interface_line_id = l.interface_line_id
WHERE l.batch_source_name = :batch_source
GROUP BY l.interface_line_attribute1, e.message_text

### Resubmitting safely

**Body:**

Rejected rows stay in the interface until corrected or purged, and a resubmit picks up the unprocessed rows. Check the Purge Interface Tables option on the batch source: if purging is on, rejected rows can be removed and you must reload them from source. Confirm what your source setting does before resubmitting a large run.

Do not resubmit blindly after a partial success. Reconcile the number of transactions created against the source system document count first, to avoid duplicate invoices when a feeding job also retries on its own.

## Pitfalls

- Fixing the rejected line but not the batch source or AutoAccounting rule, so the next run rejects again.
- Resubmitting a batch after partial success without reconciling, which can duplicate invoices when the upstream also retries.
- Ignoring grouping: correcting one line while its siblings in the same group remain rejected.
- Missing daily conversion rates for the transaction date and rate type on foreign currency billing.
- Assuming rejected rows are retained when the batch source is set to purge the interface.

## Ai Angle

A grounded assistant such as ERPray can group the rejected interface lines by message and batch source, then tell you that most rejections point to one inactive transaction type or one customer site, citing the rows. Because it is read-only by default and shows its query, finance can verify the finding. Corrections to interface data or setup still go through your normal change control.

## Faq

### Where do I see why an AutoInvoice line was rejected?

**Answer:** Open the Import AutoInvoice Execution Report from the scheduled process output, then use the Manage AutoInvoice Exceptions task. Each rejected line carries a message and the attribute that failed. The underlying messages live in the interface errors table.

### Why did a whole invoice disappear when only one line was bad?

**Answer:** Lines are grouped into a transaction using the grouping rule on the batch source. If one line in the group fails validation, the transaction cannot be created cleanly, so related lines are rejected with it. Fix the failing line and resubmit the batch.

### Can I just edit the interface data and rerun?

**Answer:** Yes for many fields through the exceptions task, but check the source's purge setting and your upstream retry logic first. If the feeding system will also reload the data, edit at the source to avoid a mismatch or duplicates.

### Why does AutoInvoice fail on revenue accounts?

**Answer:** When accounts are not supplied, AutoAccounting derives them. If a rule is missing, a segment cannot be derived, or the combination fails cross-validation or is end-dated, the line is rejected. Review AutoAccounting setup for the business unit.

## Search terms

Import AutoInvoice errors, Fusion Receivables AutoInvoice, RA_INTERFACE_ERRORS_ALL, Manage AutoInvoice Exceptions, Fusion transaction source setup, Oracle Fusion AR billing errors, AutoAccounting rules Fusion, AutoInvoice grouping rule

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json