FBDI GUIDE — SUPPLIERS

    How to Migrate Suppliers to Oracle Fusion

    Supplier master is foundational — Payables, Procurement and spend all depend on it. This guide covers importing suppliers into Oracle Fusion via the Supplier Import FBDI (the POZ supplier interface), the supplier/address/site/contact hierarchy, deduplication, and how to reconcile counts and balances.

    Supplier FBDI
    POZ interface
    4 levels
    Supplier→site→contact
    Dedup
    Clean on the way
    Reconciled
    Counts & balances

    What it takes to migrate suppliers correctly

    The Fusion supplier model is hierarchical — supplier, supplier address, supplier site and supplier contact — and the import loads through the POZ supplier interface tables. Getting the hierarchy and keys right is the whole job.

    You map legacy vendors to the Fusion supplier hierarchy, decide a dedup strategy (legacy masters are full of duplicates), and load through the Supplier Import FBDI, which stages into the POZ supplier interface tables before creating suppliers, addresses, sites and contacts.

    Migration is the right moment to cleanse: merge duplicates, retire inactive vendors and standardize tax/bank details. After load, reconcile supplier counts and, where AP open items are migrated, supplier balances.

    Key concepts for supplier migration

    The Fusion supplier hierarchy.

    🏢

    Supplier

    The top-level party — name, tax registration, classifications.

    📍

    Supplier address

    Reusable addresses associated with the supplier.

    🏬

    Supplier site

    Business-unit-specific purchasing/payment sites.

    👤

    Supplier contact

    Contacts linked to the supplier and sites.

    🗃️

    POZ interface tables

    Supplier Import FBDI stages here before creating records.

    🧹

    Deduplication

    Merge duplicate vendors and retire inactive ones before load.

    Step-by-step: importing suppliers via FBDI

    The mechanical sequence.

    1

    Extract & profile vendors

    Pull the legacy vendor master with addresses, sites, contacts, tax and bank details; profile for duplicates.

    2

    Dedup & cleanse

    Merge duplicates, retire inactive vendors, standardize tax IDs and banking.

    3

    Map to the hierarchy

    Map legacy fields to supplier, address, site and contact templates.

    4

    Generate Supplier FBDI

    Populate the Supplier Import templates and load (stages into POZ interface tables).

    5

    Import & fix errors

    Run the import, review rejections (tax, country, BU, duplicates) and re-load iteratively.

    6

    Reconcile

    Match supplier/site counts to the cleansed source and, if AP is migrated, supplier balances.

    Common supplier migration pitfalls

    What trips teams up.

    Duplicates carried over

    Loading legacy duplicates pollutes Fusion — dedup first.

    Broken hierarchy keys

    Address/site/contact must reference the right supplier.

    Invalid tax/country data

    Bad tax registrations and country codes fail validation.

    Missing BU assignment

    Sites must map to valid business units.

    Bank detail errors

    Payment/bank data must be valid for net pay to suppliers.

    Automate & reconcile

    Pre-built extraction, dedup and FBDI generation with count reconciliation.

    Frequently asked questions

    How do you import suppliers into Oracle Fusion?+

    Map your legacy vendor master to the Fusion supplier hierarchy (supplier, address, site, contact), deduplicate and cleanse, then load via the Supplier Import FBDI, which stages into the POZ supplier interface tables before creating the records. Finally, reconcile supplier and site counts (and balances if AP is in scope).

    What are the POZ supplier interface tables?+

    POZ is the Oracle Fusion supplier interface area (e.g. POZ_SUPPLIERS_INT and related tables) that the Supplier Import FBDI stages data into before the import process creates suppliers, addresses, sites and contacts. Errors surface against these staged rows for correction.

    How do I handle duplicate suppliers?+

    Deduplicate before loading — profile the legacy master, merge duplicates, retire inactive vendors and standardize tax/bank details. Migration is the best opportunity to clean the supplier base rather than replicate legacy mess.

    Do I migrate supplier balances too?+

    Supplier (AP) open balances are migrated through the Payables open-invoice load, not the supplier master FBDI. Suppliers are loaded first, then open AP invoices reference them; both are reconciled.

    Can supplier migration be automated?+

    Yes — Syntra ETL automates vendor extraction, deduplication, mapping to the supplier hierarchy, Supplier Import FBDI generation and count reconciliation.

    Get Help With Supplier Migration

    Tell us your source system and we'll cleanse, dedup and load your suppliers into Oracle Fusion with reconciliation.