The Oracle Fusion Receivables AutoInvoice FBDI — RA_INTERFACE_LINES_ALL and companions — the key columns, batch sources, and how to load with Import AutoInvoice.
| Worksheet / interface | What it holds |
|---|---|
RA_INTERFACE_LINES_ALL | Transaction lines — customer, transaction type, batch source, amounts, tax |
RA_INTERFACE_DISTRIBUTIONS_ALL | Revenue / receivable distributions (optional if auto-derived) |
RA_INTERFACE_SALESCREDITS_ALL | Sales credits (optional) |
Load with Import AutoInvoice, specifying the transaction (batch) source.
Get the object’s FBDI spreadsheet (.xlsm) from Oracle’s File-Based Data Import guide for your Fusion release.
Populate the required and conditionally-required columns; leave system-derived columns blank.
Use the template’s “Generate CSV File” macro, then ZIP the resulting .csv file(s).
Run the Load Interface File for Import scheduled process, selecting the import job and your ZIP — data lands in the interface tables.
Run the object’s import process to move data from interface tables to base tables.
Check the import output/error report, fix rejected rows, reload, and reconcile record counts source-to-target.
The AutoInvoice FBDI, which populates RA_INTERFACE_LINES_ALL (and optionally distributions and sales-credit tables), loaded with the Import AutoInvoice scheduled process.
A valid transaction batch source and transaction type, active customer bill-to/ship-to, valid accounting combinations, and correct line types for line/tax/freight rows.
Syntra generates and loads FBDI/HDL for every object at scale — with source extraction, mapping and reconciliation built in. Skip the hand-built templates.