Oracle Fusion Supply Chain Management (SCM) involves a broad set of functionalities, and its data is stored across various tables in the Oracle Fusion database. However, it’s important to note that accessing these tables directly may not always be recommended or supported by Oracle, especially for reporting purposes or integrations. Oracle typically suggests using views or APIs for such purposes.

That said, here are some of the key tables in Oracle Fusion SCM:

1. Item Tables: These tables store information about items (products) managed within the SCM system.

   • EGO_ITEM_E (Item entity)
   • EGO_MTL_SY_ITEMS_B (Master item table)

2. Inventory Tables: These are used for managing inventory levels, locations, and transactions.

   • INV.MTL_SYSTEM_ITEMS_B (Defines items at the organization level)
   • INV.MTL_ONHAND_QUANTITIES (Stores on-hand material quantities)

3. Order Management Tables: These tables manage information related to customer orders.

   • DOO_HEADERS_ALL (Order headers)
   • DOO_LINES_ALL (Order lines)

4. Purchasing Tables: These tables handle data related to procurement processes.

   • PO_HEADERS_ALL (Purchase order headers)
   • PO_LINES_ALL (Purchase order lines)

5. Cost Management Tables: These are used for tracking and managing costs associated with SCM activities.

   • CST_ITEM_COSTS (Stores item costs)

6. Receiving Tables: Involved in the management of goods received.

   • RCV_SHIPMENT_HEADERS (Shipment header information)
   • RCV_TRANSACTIONS (Receiving transactions)

7. Bill of Materials (BOM) Tables: These tables manage data related to the bill of materials.

   • BOM_BILL_OF_MATERIALS (Stores BOM information)
   • BOM_COMPONENTS_B (Stores BOM component details)

These tables are a part of the broader Oracle Fusion Applications schema and are integral to various business processes within SCM. It’s also worth noting that Oracle Fusion applications are often updated, and table structures may change across versions. Additionally, the actual table names can vary based on the implementation and customization.

For detailed and specific information, it’s recommended to refer to Oracle’s official documentation or consult with an Oracle Fusion SCM expert. Additionally, when handling these tables, it’s crucial to follow best practices and guidelines provided by Oracle to ensure data integrity and system stability.