The Oracle Fusion PO Import FBDI — headers, lines, schedules and distributions — the key columns, the BU/supplier-site/buyer pitfalls, and how to load with Import Orders.
| Worksheet / interface | What it holds |
|---|---|
PO_HEADERS_INTERFACE | PO header — supplier, site, BU, document style, buyer, currency |
PO_LINES_INTERFACE | Lines — item, category, description, UOM, price |
PO_LINE_LOCATIONS_INTERFACE | Schedules — ship-to, quantity, dates |
PO_DISTRIBUTIONS_INTERFACE | Distributions — charge account, requisitioning BU |
Load with the Import Orders scheduled process. The same interfaces cover standard POs, blanket (BPA) and contract (CPA) agreements by document style.
Bill-to / requisitioning / procurement BU must all align and be valid on every rowGet 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.
Real PO/BPA/CPA load at scale: Procurement migration case study →
The PO Import FBDI, which populates PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, PO_LINE_LOCATIONS_INTERFACE and PO_DISTRIBUTIONS_INTERFACE, loaded with the Import Orders scheduled process.
Yes — blanket and contract purchase agreements load through the same Import Orders interfaces, distinguished by document style.
Typically business-unit and supplier-site validity, invalid buyers, duplicate document numbers, inactive document styles, and headers without matching lines. Validate against the targets before loading.
Syntra generates and loads FBDI/HDL for every object at scale — with source extraction, mapping and reconciliation built in. Skip the hand-built templates.