# Oracle Fusion Supplier Table, Organization Table and Supplier Error Tables > Source: https://netray.co/tools/oracle-fusion-supplier-and-organization-tables-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A reference for the Oracle Fusion supplier table, organization tables, and the FBDI interface and error tables used when supplier loads fail. ## Category oracle ## Erp Oracle Fusion Cloud SCM ## Audience - Fusion report developer - Procurement analyst - Data migration lead ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Area **Key:** area **Type:** select **Options:** - Supplier - Supplier interface and errors - Organization - Manufacturing #### What it holds **Key:** purpose **Type:** text #### Key and join columns **Key:** keys **Type:** text **Rows:** **Table:** POZ_SUPPLIERS **Area:** Supplier **Purpose:** Supplier header record: supplier number, type, enabled flag and active dates **Keys:** VENDOR_ID, PARTY_ID, SEGMENT1 **Table:** HZ_PARTIES **Area:** Supplier **Purpose:** Trading community party record that holds the supplier name **Keys:** PARTY_ID, PARTY_NAME **Table:** POZ_SUPPLIER_SITES_ALL_M **Area:** Supplier **Purpose:** Supplier sites, one row per site and procurement business unit **Keys:** VENDOR_SITE_ID, VENDOR_ID, PRC_BU_ID, VENDOR_SITE_CODE **Table:** POZ_SITE_ASSIGNMENTS_ALL_M **Area:** Supplier **Purpose:** Assignment of supplier sites to client business units **Keys:** ASSIGNMENT_ID, VENDOR_SITE_ID, BU_ID **Table:** POZ_SUPPLIER_CONTACTS **Area:** Supplier **Purpose:** Contact people attached to a supplier **Keys:** VENDOR_CONTACT_ID, VENDOR_ID **Table:** POZ_SUPPLIERS_INT **Area:** Supplier interface and errors **Purpose:** FBDI interface table for supplier header loads **Keys:** BATCH_ID, VENDOR_NAME, IMPORT_ACTION **Table:** POZ_SUPPLIER_ADDRESSES_INT **Area:** Supplier interface and errors **Purpose:** FBDI interface table for supplier addresses **Keys:** BATCH_ID, VENDOR_NAME, ADDRESS_NAME **Table:** POZ_SUPPLIER_SITES_INT **Area:** Supplier interface and errors **Purpose:** FBDI interface table for supplier sites **Keys:** BATCH_ID, VENDOR_NAME, VENDOR_SITE_CODE **Table:** POZ_SUP_CONTACTS_INT **Area:** Supplier interface and errors **Purpose:** FBDI interface table for supplier contacts **Keys:** BATCH_ID, VENDOR_NAME **Table:** POZ_SUPPLIER_INT_REJECTIONS **Area:** Supplier interface and errors **Purpose:** Rejection rows explaining why supplier import records failed **Keys:** PARENT_TABLE, PARENT_ID, REJECT_LOOKUP_CODE **Table:** INV_ORG_PARAMETERS **Area:** Organization **Purpose:** Inventory organization setup with organization code and master organization **Keys:** ORGANIZATION_ID, ORGANIZATION_CODE, MASTER_ORGANIZATION_ID **Table:** HR_ORGANIZATION_UNITS **Area:** Organization **Purpose:** Organization units used across HCM and SCM; names are held in translation tables or views **Keys:** ORGANIZATION_ID **Table:** FUN_ALL_BUSINESS_UNITS_V **Area:** Organization **Purpose:** View of business units with business unit ID and name **Keys:** BU_ID, BU_NAME **Table:** GL_LEDGERS **Area:** Organization **Purpose:** Ledgers (primary, secondary) and their currency and calendar **Keys:** LEDGER_ID, NAME, CURRENCY_CODE **Table:** WIE_WORK_ORDERS_B **Area:** Manufacturing **Purpose:** Manufacturing work order header **Keys:** WORK_ORDER_ID, WORK_ORDER_NUMBER, ORGANIZATION_ID **Table:** WIS_WORK_DEFINITIONS **Area:** Manufacturing **Purpose:** Work definition header (routing and BOM) per item and organization **Keys:** WORK_DEFINITION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID **Notes:** Names and columns vary by update. Confirm each in the Oracle Fusion Cloud SCM Tables and Views guide for your release. Many tables are reached through subject areas or views rather than direct SQL in your environment. ## Content **Intro:** The Oracle Fusion supplier table is POZ_SUPPLIERS, with supplier names held in HZ_PARTIES and sites in POZ_SUPPLIER_SITES_ALL_M. This reference also covers organization tables and the interface tables where failed supplier imports leave errors. **Sections:** #### How the supplier tables fit together **Body:** A supplier in Fusion is a header in POZ_SUPPLIERS linked by PARTY_ID to a trading community party in HZ_PARTIES, which holds the legal name. Under the header sit addresses, sites and contacts. Sites live in POZ_SUPPLIER_SITES_ALL_M and are specific to a procurement business unit through PRC_BU_ID, so one supplier can have many sites across many business units. To list active suppliers with names, join POZ_SUPPLIERS to HZ_PARTIES on PARTY_ID and filter on the enabled flag and active dates. **Bullets:** - Supplier number is SEGMENT1 in POZ_SUPPLIERS - Supplier name comes from HZ_PARTIES.PARTY_NAME - Sites are per procurement business unit, so expect several rows per supplier #### Supplier error table in Oracle Fusion **Body:** When you import suppliers by File Based Data Import, rows first land in interface tables such as POZ_SUPPLIERS_INT, POZ_SUPPLIER_SITES_INT and POZ_SUPPLIER_ADDRESSES_INT. Records that fail validation are written to POZ_SUPPLIER_INT_REJECTIONS with a reject lookup code and a reference to the parent row. The import process also produces a rejection report you can open from Scheduled Processes. Read the reject code first, fix the source file, and reload with a new batch ID rather than editing interface rows by hand. #### Organization tables in Oracle Fusion **Body:** Organization data in Fusion is spread by purpose. Inventory organizations are in INV_ORG_PARAMETERS, with ORGANIZATION_CODE and a link to the master organization. Business units are most easily read from the view FUN_ALL_BUSINESS_UNITS_V. Legal entities and ledgers have their own tables such as GL_LEDGERS. HR organization units appear in HR tables, where names are often stored in translation tables, so names may need a language filter. Pick the table by the question you are answering: inventory, procurement, financial or HR. #### BI Publisher query tips **Body:** Start with a narrow query, for example suppliers created in the last 30 days, and add joins one at a time. Always filter on active dates and the enabled flag when you want only usable suppliers. Use a data model with parameters instead of hard-coded values, and avoid selecting every column from large tables. For ad hoc analysis, the Supplier subject areas in OTBI apply security and need no SQL. If direct table access is blocked in your environment, request a BI Publisher data source role from your Fusion administrator. **Cta:** Netray can put a private AI layer over your Oracle Fusion data so buyers ask supplier questions in plain English instead of requesting new reports. It can be deployed on-prem or in your private cloud. **Faq:** #### What is the supplier table in Oracle Fusion? **Answer:** The supplier header table is POZ_SUPPLIERS, joined to HZ_PARTIES for the name, and POZ_SUPPLIER_SITES_ALL_M for sites. Confirm the exact columns for your update in the Tables and Views guide. #### Where are supplier import errors stored? **Answer:** Failed supplier import rows are recorded in the rejection table POZ_SUPPLIER_INT_REJECTIONS, and the import also produces a rejection report. Read the reject code, fix the source data and reload with a new batch. #### What is the organization table in Oracle Fusion? **Answer:** There is no single table. Inventory organizations are in INV_ORG_PARAMETERS, business units are readable through FUN_ALL_BUSINESS_UNITS_V, and HR organization units sit in HR tables. Choose by the type of organization. #### Can I query these tables directly? **Answer:** Often through BI Publisher with the right data access role, but some are better reached through OTBI subject areas. Your Fusion administrator controls what is available in your environment. ## Search terms oracle fusion supplier table, oracle fusion suppliers table, supplier error table in oracle fusion, oracle fusion organization table, organization table oracle fusion, oracle cloud manufacturing tables, POZ_SUPPLIERS, INV_ORG_PARAMETERS --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json