SCM Table In Oracle Fusion
SCM Table In Oracle Fusion
Oracle Fusion Supply Chain Management (SCM) is a cloud-based solution that integrates and automates all key supply chain processes, from design, planning, and procurement to manufacturing and order fulfillment. Oracle Fusion SCM leverages data-driven insights to guide your business to more streamlined and efficient processes.
Oracle Fusion SCM, like all Oracle Fusion applications, is built on top of an Oracle database, which stores data in tables. While there’s no specific “SCM table,” there are numerous database tables that are used to manage and store SCM-related data. Here are a few examples of tables you may interact with when dealing with Oracle Fusion SCM:
-
FND_USERS: This table stores information about all users in the system. -
PO_HEADERS_ALL: Stores information about all purchase order headers, regardless of the purchase order type. -
PO_LINES_ALL: Contains information about the line level details of a purchase order. -
INV_ITEMS: Contains information about inventory items, which are essential to the supply chain management process. -
OE_ORDER_HEADERS_ALL: Contains information about sales order headers. -
OE_ORDER_LINES_ALL: Contains information about sales order lines.
These are just a few examples. The specific tables and their structures will depend on the exact modules you are using within the Oracle Fusion SCM suite, as well as any customizations you may have implemented.