Oracle Fusion SCM Table Names

Share

Oracle Fusion SCM Table Names

Oracle Fusion Supply Chain Management (SCM) is a comprehensive suite of applications designed to manage various aspects of supply chain operations. Some common table names associated with Oracle Fusion SCM:

 

  1. INV_ITEMS: This table stores information about inventory items, including their descriptions, units of measure, and other attributes.
  2. PO_HEADERS_ALL: This table contains header-level information for purchase orders, including details like the purchase order number, supplier information, and order status.
  3. PO_LINES_ALL: This table stores line-level information for purchase orders, including item details, quantities, and prices.
  4. PO_DISTRIBUTIONS_ALL: It holds distribution-level information for purchase orders, including accounting information related to the distribution of costs.
  5. PO_REQ_HEADERS_ALL: This table stores header-level information for purchase requisitions, including requisition numbers, requester details, and dates.
  6. PO_REQ_LINES_ALL: It contains line-level information for purchase requisitions, including the requested item, quantity, and related details.
  7. INV_TRANSACTIONS: This table records various inventory transactions, such as issues, receipts, and transfers, with details like transaction types, quantities, and locations.
  8. OM_ORDER_HEADERS_ALL: In the context of SCM, this table stores header-level information for sales orders, including order numbers, customer details, and order status.
  9. OM_ORDER_LINES_ALL: It contains line-level information for sales orders, including item details, quantities, and pricing information.
  10. OM_SHIPMENTS: This table tracks shipments related to sales orders, including shipment numbers, shipping methods, and delivery details.
  11. WIP_JOBS: If you are dealing with manufacturing in your SCM, this table stores information about work-in-process jobs, including job numbers, status, and associated items.
  12. CST_COST_TXN_DETAIL: This table is related to cost transactions in SCM and contains details about cost transactions, including cost types and amounts.

Share

Leave a Reply

Your email address will not be published. Required fields are marked *