The Supplier Import FBDI worksheets and interface tables — supplier, address, site, site assignment, contact and bank — the key columns, and how to load them with the Import Suppliers job.
The Supplier Import FBDI is a multi-worksheet template: a supplier isn’t one row, it’s a set of linked records loaded together. Each worksheet maps to an interface table:
| Worksheet / interface | What it holds |
|---|---|
POZ_SUPPLIERS_INT | Supplier header — name, number, tax organization type, business relationship |
POZ_SUPPLIER_ADDRESSES_INT | Supplier addresses |
POZ_SUPPLIER_SITES_INT | Supplier sites (purchasing, payment) |
POZ_SUP_SITE_ASSIGNMENTS_INT | Site-to-business-unit assignments |
POZ_SUPPLIER_CONTACTS_INT | Supplier contacts |
Supplier bank accounts are loaded separately (via the external bank-account import). Load the whole set with the Import Suppliers scheduled process.
Tax Organization Type and Business Relationship (e.g. SPEND_AUTHORIZED) are commonly requiredProcurement BU and carry the purchasing purposeGet 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.
Migration walkthrough: Migrate suppliers to Oracle Fusion →
Real 18-BU supplier load: Supplier master migration case study →
Oracle Fusion’s File-Based Data Import for suppliers — a multi-worksheet template covering supplier headers (POZ_SUPPLIERS_INT), addresses, sites, site-to-BU assignments and contacts, loaded via the Import Suppliers scheduled process.
Populate the POZ_SUPPLIER_ADDRESSES_INT and POZ_SUPPLIER_CONTACTS_INT worksheets in the same Supplier Import template, generate the CSV, upload via Load Interface File for Import, and run Import Suppliers — addresses and contacts load with the supplier.
Usually master-data gaps and target mismatches — classification as text instead of codes, sites not valid for the procurement BU, inactive site assignments, or duplicates on re-load. Validate against the Fusion 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.