Key Reference Tables in Oracle Cost Management Cloud

 

Key Database Tables in Oracle SCM Cost Management

This blog provides a list of the key database tables from Oracle SCM Cost Management module. In Oracle Fusion SCM, the Cost Management module plays a critical role in ensuring accurate valuation of inventory, recording of manufacturing costs, and generation of accounting entries for all supply chain transactions. To support this, Oracle Fusion maintains a robust set of database tables that capture transaction details, costing data, accounting distributions, and configuration setups.

Below is a list of the key database tables and views used in Oracle Fusion Cost Management. These tables form the backbone of the costing engine — linking Inventory, Procurement, Manufacturing, and Accounting data to derive financial impact for every supply chain event.

Each table serves a specific role, whether it’s storing transaction-level cost entries, maintaining item cost profiles, managing cost books, or tracking accounting events and journal lines. Understanding these tables is crucial for functional consultants, developers, and support analysts.

 

Sr. No.	Module	Table Name	Description
1	Cost Management	CST_STD_COSTS	Stores the information pertaining to standard costs.
2	Cost Management	CST_COST_DISTRIBUTIONS	This table contains the distribution header information for the costing transactions. Distribution processor creates data in this table before it is accounted into SLA
3	Cost Management	CST_COST_DISTRIBUTION_LINES	This table contains the distribution details such as debits, credits and the distribution amounts.
4	Cost Management	CST_COST_BOOKS_B	This table contains the cost book codes. Cost book is an independent entity and does not require/depend on any other setup.
5	Cost Management	CST_COST_ELEMENTS_B	This is the base table of all cost elements defined in cost management. These cost elements help in providing break-up of item cost into various elements.
6	Cost Management	CST_COST_PROFILES_B	This table contains the cost profiles setup by the user.
7	Cost Management	CST_DEFAULT_COST_PROFILES	This table contains the default cost profiles which are identified by Cost Organization, Cost Book and Category. Default cost profiles are setup in context of cost organization and cost books.
8	Cost Management	CST_COST_ORG_BOOKS	This table contains the Cost organization and cost book association. It describes the Ledger, calendar, currency, accounting attributes of the defined cost-org book.
9	Cost Management	CST_VAL_UNITS_B	This table contains the valuation unit codes. Valuation units are created in context of cost organization, cost book and valuation structure.
10	Cost Management	CST_TRANSACTIONS	These are costing transactions. The imported inventory transactions are converted to costing transaction type, exploded for Cost Org - Book and stamped with suitable costing setup like item cost profile, valuation unit and costing method etc.
11	Cost Management	CST_TRANSACTION_COSTS	This table holds the actual cost of receipts and issues for transactions in parent table CST_TRANSACTIONS. It holds the entire history of what each actual cost was after every adjustment, and the cost is stored in its entirety on each adjustment instead of being stored in incremental costs.
12	Cost Management	CST_RESOURCE_TRANSACTIONS	This table will contain the manufacturing resource transactions that are staged for cost processor. The transactions are staged for each cost book within the cost organization associated to the plant where the resource was consumed. In addition to the resource transactions from manufacturing, this entity will also contain the logical transaction for the WIP revaluation corresponding to the resource rate changes.
13	Cost Management	CST_RESOURCE_COSTS	This entity contains the breakup of resource cost at cost element, expense pool level, which will be used to create accounting distributions for these resource transactions.
14	Cost Management	CST_EXPENSE_POOLS_B	This table contains the information about expense pools.
15	Cost Management	CST_INV_TRANSACTIONS	This is Costing's Inventory Transactions table and is the source of all inventory transactions within costing. It contains all transactions that are imported into Costing through the interface and also transactions that are created by costing's engines during processing.
16	Cost Management	CST_PERPAVG_COST	This table contains the current and Historical perpetual average Cost
17	Cost Management	CST_TRANSFERS	Transfer Layers tracks quantity flow of in transit transactions.
18	Cost Management	CST_VU_ONHAND_VALUATIONS	This table contains inventory valuation with quantities at the VU level and the costs at total level.
19	Cost Management	CST_TRADE_EVENTS	This table contains the trade event transactions from the FOS system.
20	Product Data Hub	EGP_SYSTEM_ITEMS_B	This table contains the item information.