The Oracle Fusion Payables invoice FBDI — AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE — the key columns, PO matching, and how to load with Import Payables Invoices.
| Worksheet / interface | What it holds |
|---|---|
AP_INVOICES_INTERFACE | Invoice header — supplier, site, amount, date, invoice number, BU, currency |
AP_INVOICE_LINES_INTERFACE | Invoice lines — distributions, amounts, accounting, PO match, tax |
Load with the Import Payables Invoices scheduled process, choosing the source and import batch.
INVOICE_ID links header and lines and must be consistent across both worksheetsGet 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.
Open payables walkthrough: Migrate open AP/AR to Oracle Fusion →
The Payables Standard Invoice Import FBDI, which populates AP_INVOICES_INTERFACE (headers) and AP_INVOICE_LINES_INTERFACE (lines), loaded via the Import Payables Invoices scheduled process.
By INVOICE_ID — the same value ties each line to its header. Keep it consistent across both worksheets.
Yes — reference the matched PO and line on the invoice lines; the PO must already exist in Fusion and match on supplier, amount and business unit.
Syntra generates and loads FBDI/HDL for every object at scale — with source extraction, mapping and reconciliation built in. Skip the hand-built templates.