# Oracle Fusion Table Names and Details: SCM and Financials Reference > Source: https://netray.co/tools/oracle-fusion-table-names-scm-and-financials-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A searchable reference of widely used Oracle Fusion SCM and Financials table names with what each holds and the keys to join on. ## Category oracle ## Erp Oracle Fusion Cloud ## Audience - Fusion BI developer - Report writer - Finance analyst ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Module **Key:** module **Type:** select **Options:** - Items - Inventory - Purchasing - Receiving - Payables - Receivables - General Ledger - Order Management - Parties #### What it holds **Key:** purpose **Type:** text #### Key columns **Key:** keys **Type:** text **Rows:** **Table:** EGP_SYSTEM_ITEMS_B **Module:** Items **Purpose:** Item master by organization **Keys:** INVENTORY_ITEM_ID, ORGANIZATION_ID **Table:** EGP_SYSTEM_ITEMS_TL **Module:** Items **Purpose:** Translated item descriptions **Keys:** INVENTORY_ITEM_ID, ORGANIZATION_ID, LANGUAGE **Table:** EGP_CATEGORIES_B **Module:** Items **Purpose:** Item categories **Keys:** CATEGORY_ID **Table:** INV_ORG_PARAMETERS **Module:** Inventory **Purpose:** Inventory organization parameters **Keys:** ORGANIZATION_ID, ORGANIZATION_CODE **Table:** INV_MATERIAL_TXNS **Module:** Inventory **Purpose:** Inventory material transactions **Keys:** TRANSACTION_ID **Table:** INV_ONHAND_QUANTITIES_DETAIL **Module:** Inventory **Purpose:** On-hand quantity by item and subinventory **Keys:** INVENTORY_ITEM_ID, ORGANIZATION_ID **Table:** INV_TRANSACTION_TYPES_B **Module:** Inventory **Purpose:** Transaction type definitions **Keys:** TRANSACTION_TYPE_ID **Table:** PO_HEADERS_ALL **Module:** Purchasing **Purpose:** Purchase order header **Keys:** PO_HEADER_ID, SEGMENT1, VENDOR_ID **Table:** PO_LINES_ALL **Module:** Purchasing **Purpose:** Purchase order lines **Keys:** PO_LINE_ID, PO_HEADER_ID **Table:** PO_LINE_LOCATIONS_ALL **Module:** Purchasing **Purpose:** Purchase order schedules **Keys:** LINE_LOCATION_ID, PO_LINE_ID **Table:** PO_DISTRIBUTIONS_ALL **Module:** Purchasing **Purpose:** Purchase order distributions and charge accounts **Keys:** PO_DISTRIBUTION_ID, LINE_LOCATION_ID **Table:** POR_REQUISITION_HEADERS_ALL **Module:** Purchasing **Purpose:** Self service requisition headers **Keys:** REQUISITION_HEADER_ID **Table:** POZ_SUPPLIERS **Module:** Purchasing **Purpose:** Supplier header **Keys:** VENDOR_ID, PARTY_ID, SEGMENT1 **Table:** POZ_SUPPLIER_SITES_ALL_M **Module:** Purchasing **Purpose:** Supplier sites **Keys:** VENDOR_SITE_ID, VENDOR_ID, PRC_BU_ID **Table:** RCV_SHIPMENT_HEADERS **Module:** Receiving **Purpose:** Receipt and shipment headers **Keys:** SHIPMENT_HEADER_ID **Table:** RCV_SHIPMENT_LINES **Module:** Receiving **Purpose:** Receipt lines **Keys:** SHIPMENT_LINE_ID, SHIPMENT_HEADER_ID **Table:** RCV_TRANSACTIONS **Module:** Receiving **Purpose:** Receiving transactions such as receive and deliver **Keys:** TRANSACTION_ID **Table:** AP_INVOICES_ALL **Module:** Payables **Purpose:** Payables invoice header **Keys:** INVOICE_ID, VENDOR_ID, INVOICE_NUM **Table:** AP_INVOICE_LINES_ALL **Module:** Payables **Purpose:** Payables invoice lines **Keys:** INVOICE_ID, LINE_NUMBER **Table:** AP_INVOICE_DISTRIBUTIONS_ALL **Module:** Payables **Purpose:** Payables invoice distributions **Keys:** INVOICE_DISTRIBUTION_ID, INVOICE_ID **Table:** AP_INVOICES_INTERFACE **Module:** Payables **Purpose:** Payables invoice import interface header **Keys:** INVOICE_ID **Table:** AP_INTERFACE_REJECTIONS **Module:** Payables **Purpose:** Rejection reasons for payables import **Keys:** PARENT_TABLE, PARENT_ID **Table:** RA_CUSTOMER_TRX_ALL **Module:** Receivables **Purpose:** Receivables transaction (invoice) header **Keys:** CUSTOMER_TRX_ID, TRX_NUMBER **Table:** AR_PAYMENT_SCHEDULES_ALL **Module:** Receivables **Purpose:** Receivables payment schedules and balances due **Keys:** PAYMENT_SCHEDULE_ID, CUSTOMER_TRX_ID **Table:** GL_JE_HEADERS **Module:** General Ledger **Purpose:** Journal entry headers **Keys:** JE_HEADER_ID, LEDGER_ID **Table:** GL_JE_LINES **Module:** General Ledger **Purpose:** Journal entry lines **Keys:** JE_HEADER_ID, JE_LINE_NUM **Table:** GL_CODE_COMBINATIONS **Module:** General Ledger **Purpose:** Accounting flexfield combinations **Keys:** CODE_COMBINATION_ID **Table:** GL_BALANCES **Module:** General Ledger **Purpose:** Account balances by period **Keys:** LEDGER_ID, CODE_COMBINATION_ID, PERIOD_NAME **Table:** GL_LEDGERS **Module:** General Ledger **Purpose:** Ledger definitions **Keys:** LEDGER_ID **Table:** DOO_HEADERS_ALL **Module:** Order Management **Purpose:** Order orchestration (sales order) headers **Keys:** HEADER_ID **Table:** DOO_LINES_ALL **Module:** Order Management **Purpose:** Order orchestration lines **Keys:** LINE_ID, HEADER_ID **Table:** HZ_PARTIES **Module:** Parties **Purpose:** Trading community parties including supplier and customer names **Keys:** PARTY_ID, PARTY_NAME **Table:** HZ_CUST_ACCOUNTS **Module:** Parties **Purpose:** Customer accounts **Keys:** CUST_ACCOUNT_ID, PARTY_ID, ACCOUNT_NUMBER **Notes:** A manufacturer is normally modelled as an item attribute (manufacturer part number relationships under Items) or as a supplier, not as its own standalone table. Confirm names and columns for your release in the Oracle Fusion Tables and Views guide. ## Content **Intro:** This is a searchable list of Oracle Fusion table names across SCM and Financials, with what each holds and its key columns. It is meant for BI Publisher and OTBI developers writing their first reports. **Sections:** #### How to use the table list **Body:** Filter by module, then search by table name or purpose. Use the key columns column to plan joins: header tables join to lines on the header ID, and organization-specific tables join on both item ID and organization ID. Tables ending _ALL hold data for every business unit and need an organization or business unit filter, while _B tables hold base columns and _TL tables hold translated text. Export the filtered list to Excel to keep it with your report design. #### Naming patterns in Fusion tables **Body:** Fusion tables inherit naming conventions from Oracle E-Business Suite, which helps if you moved from EBS. A prefix names the product: PO for purchasing, AP for payables, GL for the general ledger, INV for inventory, EGP for product information, HZ for trading community, and DOO for order orchestration. Suffix patterns matter too: _ALL means multi-organization, _B base, _TL translated, _INT interface. Not every EBS table survived the move, so never assume an EBS table exists in Fusion. **Bullets:** - _ALL: all business units, filter on BU or org - _B and _TL: base and translated pairs, filter the language - _INT: interface tables used during import #### Manufacturer table in Oracle Fusion **Body:** People often search for a manufacturer table. In Fusion the manufacturer is not a separate main master like the supplier table. Manufacturers and their part numbers are held as relationships on the item in Product Information Management, and a manufacturing company will often also hold the manufacturer as a supplier in the supplier tables. For reporting, start from the item and look for manufacturer part number relationships in the subject area first, then confirm table names in the Tables and Views guide. #### Choosing between OTBI and direct SQL **Body:** OTBI subject areas are the right default for business users, because they apply security and handle translation. Use BI Publisher with SQL when you need an operational report with exact layout or joins that no subject area offers. Keep SQL queries small, parameterized and tested with a limited date range. Document every table you use so the next developer can verify it after a quarterly update changes a view or column. **Cta:** If your team spends its time writing Fusion reports for routine questions, Netray can add a private natural-language layer over the same data. It can run on-prem and respects Fusion roles. **Faq:** #### How do I find Oracle Fusion table names? **Answer:** Use the Oracle Fusion Cloud Tables and Views guide for your release, which lists tables and columns by product. This page lists the most-used ones. You can also inspect the data model of a delivered BI Publisher report. #### What do _ALL, _B and _TL mean? **Answer:** _ALL means the table holds data for multiple business units and needs a filter. _B is the base table, and _TL holds translated text per language. Filter _TL tables on language to avoid duplicate rows. #### Is there a manufacturer table in Oracle Fusion? **Answer:** Not as a single main master. Manufacturer and manufacturer part number relationships are held with the item in Product Information Management, and manufacturers are often also set up as suppliers. #### Are EBS tables the same in Fusion? **Answer:** Many names look similar, such as PO_HEADERS_ALL, but columns and structures differ and some EBS tables do not exist. Validate each table and column in the Fusion documentation instead of porting EBS queries directly. ## Search terms oracle fusion table names, oracle fusion table details, manufacturer table in oracle fusion, oracle fusion scm tables, oracle fusion financials tables, oracle fusion po tables, oracle fusion ap invoice tables, oracle fusion bip tables list --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json