Import Invoices into Oracle Fusion Using FBDI

Jun 17, 2026

Try it now: upload an invoice and get a clean Excel or CSV file in seconds.

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your invoices

Extract invoices →

Oracle Fusion Cloud ERP will create a whole batch of payables invoices from one spreadsheet, but only when the data lands in the File-Based Data Import template exactly the way Oracle expects, with a supplier and site that match, a business unit on every header, and a valid distribution on every line. It will not read a PDF or a scanned image. So the job has two halves: turn your invoice documents into clean rows, then load those rows through the Payables import process. This guide walks through both, with the menu path, the interface tables, how suppliers are matched, and the errors that stop an import. If your invoices are still PDFs or photos, drop them into the converter at the top of this page first and you will have an import-ready file in a few minutes.

Can you import invoices into Oracle Fusion?

Yes. Oracle Fusion imports payables invoices in bulk through File-Based Data Import, known as FBDI. You fill a predefined spreadsheet template, generate a CSV, and load it through a scheduled process that stages the data and then creates the invoices. The catch is that Oracle does not read invoice documents, so a PDF or photo has to be converted into structured rows before any of this works. Once your data is in the template, a month of invoices loads in one pass instead of being keyed one at a time on the Create Invoice page.

How do I import payables invoices in Oracle Fusion?

Download the Payables invoice FBDI template, fill the Invoice Header and Invoice Lines sheets, save the data as CSV, and load it. The full sequence runs like this:

  • Get the template from the File-Based Data Import guide for the Import Payables Invoices process.
  • Paste your invoice data into the Invoice Header sheet and the Invoice Lines sheet, keeping one invoice tied to its lines.
  • Add the business unit, supplier, supplier site, and a distribution combination or distribution set for each line.
  • Use the template macro to generate the CSV and zip it.
  • Run the Load Interface File for Import scheduled process to populate the open interface tables.
  • Run the Import Payables Invoices process to create the invoices, then review the report and validate.

The part that takes real time is building those rows from PDFs. Converting the documents first with an Oracle Fusion invoice import converter gives you the supplier, dates, line items, and amounts already structured, so you only add the Oracle-specific fields.

What is FBDI in Oracle Fusion?

FBDI, or File-Based Data Import, is Oracle Fusion's standard way to load data in bulk. For payables it is a macro-enabled spreadsheet template with predefined columns that map to Oracle's open interface tables. You populate it, generate a CSV, and run the Load Interface File for Import process, which moves the rows into staging. A second process then validates and creates the records. Because it is built for volume and runs as a scheduled job, FBDI is the path most AP teams and consultants use for anything beyond a handful of invoices.

Which interface tables do payables invoices load into?

Payables invoices load into two open interface tables: AP_INVOICES_INTERFACE for the header and AP_INVOICE_LINES_INTERFACE for the lines. The Invoice Header sheet in the FBDI template feeds the first, carrying the supplier, business unit, invoice number, date, and amount. The Invoice Lines sheet feeds the second, carrying each line with its amount, distribution, and tax. The two are tied together by an invoice identifier, so the import groups every line under the matching header. When that link breaks, lines either reject or post under the wrong invoice.

What is the difference between FBDI and ADFDI?

FBDI loads a CSV through a scheduled process and is built for high volume, staging the data in the interface tables before it becomes invoices. ADFDI, the Create Invoices in Spreadsheet add-in, connects an Excel workbook directly to Oracle for smaller, interactive entry where you submit rows straight from the sheet. Both still expect structured data, so neither reads a PDF. For a monthly batch of supplier invoices, FBDI is the usual choice; for a few one-off entries, ADFDI is quicker to open.

Can Oracle Fusion import PDF invoices directly?

No. FBDI reads a structured CSV, ADFDI reads an Excel sheet, and the Create Invoice page expects manual entry, so none of them turn a PDF or image into an invoice on their own. Oracle does offer Intelligent Document Recognition for invoice imaging in larger deployments, but that is a separate configured capability, not the FBDI path. For most teams the simplest route is to convert the PDF to rows first, then load those rows. That is exactly what the converter at the top of this page produces.

How do I match invoices to the right supplier in Oracle Fusion?

Oracle resolves the vendor by supplier and supplier site against the supplier master, not by the company name printed on the invoice, and it also needs the correct business unit on the header. Add all three to each invoice before you load the file. A supplier with no matching site, or a site that belongs to a different business unit, is one of the most common reasons a header rejects. Keeping a simple lookup of supplier name to supplier and site makes mapping your extracted data fast and reliable.

Why is my Oracle Fusion invoice import failing?

Most rejected rows trace back to a few causes: a supplier or site that does not match the master, a missing business unit, an invalid distribution combination, a header and line that do not share the same invoice, a wrong currency or date format, or a changed column order in the template. The Import Payables Invoices process produces a report that names the reason for each rejected row. Fix those fields in your spreadsheet, reload the corrected file through Load Interface File for Import, and run the import again. Do not delete or reorder template columns, since that alone will fail the load.

Can I import invoices into Oracle Fusion with a REST API?

Yes. Oracle Fusion exposes an AP invoices REST API that integration teams use to create invoices from another system without a spreadsheet, which suits a steady, automated feed rather than a periodic batch. It still needs structured data with a valid supplier, site, business unit, and distribution, so the same preparation applies. Many teams use FBDI for backlogs and month-end loads and reserve the API for an ongoing integration. Either way, the documents have to become clean data first.

From PDF invoices to an Oracle-ready file

The slow part of importing invoices into Oracle Fusion is never the scheduled process. It is turning a stack of PDFs and scans into the exact rows the FBDI template wants. InvoiceXLSX reads each PDF or photo with AI and returns the supplier, invoice number, dates, line items, tax, and totals as structured rows, with one invoice number carried across its lines. Paste that into the Invoice Header and Invoice Lines sheets, add the business unit, supplier, site, and distribution, and you have an import-ready file. See the import invoices to Oracle Fusion page for the full converter, and the invoice line item extraction guide for how multi-line invoices become clean rows. If you want the raw spreadsheet first, the extract invoice data to Excel walkthrough and the invoice PDF to CSV converter cover that step, and the how to import invoices into an ERP overview compares the path for every accounting system. When you reconcile those posted invoices against what actually cleared the bank, converting the statement with a bank statement to Excel converter puts both sides in one spreadsheet. Build the file once, and a monthly stack of invoices loads in minutes instead of an afternoon.