Search Results cst_cost_updates
Deep Dive into CST_COST_UPDATES Table in Oracle EBS 12.1.1/12.2.2
The CST_COST_UPDATES table is a critical component of Oracle E-Business Suite's (EBS) Cost Management module, specifically designed to track and manage cost updates for inventory items. It serves as a transactional repository for cost adjustments, ensuring accurate inventory valuation and financial reporting. This table is particularly relevant in manufacturing, distribution, and retail environments where precise cost control is essential.
Key Functional Areas:
- Cost Adjustments: Records manual or system-generated cost updates for items, including standard cost changes, average cost recalculations, or FIFO/LIFO layer adjustments.
- Audit Trail: Maintains historical records of cost changes with timestamps, user IDs, and reason codes for compliance and troubleshooting.
- Integration Hub: Interfaces with GL (General Ledger), INV (Inventory), and BOM (Bill of Materials) modules to ensure cost consistency across applications.
Technical Structure (Key Columns):
Column | Data Type | Description |
---|---|---|
COST_UPDATE_ID | NUMBER | Primary key, sequence-generated identifier |
INVENTORY_ITEM_ID | NUMBER | References MTL_SYSTEM_ITEMS_B |
ORGANIZATION_ID | NUMBER | Org where cost change applies |
OLD_COST | NUMBER | Previous item cost |
NEW_COST | NUMBER | Updated cost value |
UPDATE_DATE | DATE | When change occurred |
LAST_UPDATE_DATE | DATE | Audit column |
COST_TYPE_ID | NUMBER | Links to CST_COST_TYPES |
Version-Specific Considerations:
- 12.1.1: Requires manual reconciliation with GL after cost updates. Limited support for real-time cost simulations.
- 12.2.2: Enhanced with Web ADI integration for bulk updates and improved cost change impact analysis reports.
Business Process Flow: When a cost engineer updates an item's cost through the "Define Item Costs" form, Oracle:
- Validates the change against existing transactions
- Creates a record in CST_COST_UPDATES
- Generates accounting entries in CST_ACCOUNTING_EVENTS
- Updates MTL_MATERIAL_TRANSACTIONS for inventory valuation
Performance Considerations: In high-volume environments, this table should be:
- Indexed on INVENTORY_ITEM_ID, ORGANIZATION_ID, and UPDATE_DATE
- Purged periodically via Concurrent Program "Purge Cost History"
- Partitioned in 12.2.2 for large implementations
Customization Warning: Direct DML operations on this table require:
- Invocation of CSTPCCU.pls (Cost Processor API)
- Subsequent GL reconciliation
- Full regression testing of cost rollup processes
-
Table: CST_COST_UPDATES
12.2.2
owner:BOM, object_type:TABLE, fnd_design_data:BOM.CST_COST_UPDATES, object_name:CST_COST_UPDATES, status:VALID, product: BOM - Bills of Material , description: Cost update history , implementation_dba_data: BOM.CST_COST_UPDATES ,
-
Table: CST_COST_UPDATES
12.1.1
owner:BOM, object_type:TABLE, fnd_design_data:BOM.CST_COST_UPDATES, object_name:CST_COST_UPDATES, status:VALID, product: BOM - Bills of Material , description: Cost update history , implementation_dba_data: BOM.CST_COST_UPDATES ,
-
APPS.BOM_CSTRUSTA_XMLP_PKG dependencies on CST_COST_UPDATES
12.1.1
-
APPS.BOM_CSTRUSIA_XMLP_PKG dependencies on CST_COST_UPDATES
12.2.2
-
APPS.DPP_ITEMCOST_PVT dependencies on CST_COST_UPDATES
12.1.1
-
APPS.BOM_CSTRPMDD_XMLP_PKG dependencies on CST_COST_UPDATES
12.2.2
-
APPS.DPP_ITEMCOST_PVT dependencies on CST_COST_UPDATES
12.2.2
-
APPS.BOM_CSTRUSIA_XMLP_PKG dependencies on CST_COST_UPDATES
12.1.1
-
APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on CST_COST_UPDATES
12.1.1
-
APPS.INV_OBJECT_GENEALOGY dependencies on CST_COST_UPDATES
12.2.2
-
APPS.BOM_CSTRUSIW_XMLP_PKG dependencies on CST_COST_UPDATES
12.1.1
-
APPS.INV_OBJECT_GENEALOGY dependencies on CST_COST_UPDATES
12.1.1
-
APPS.INV_INVTRDST_XMLP_PKG dependencies on CST_COST_UPDATES
12.2.2
-
APPS.BOM_CSTRUSIW_XMLP_PKG dependencies on CST_COST_UPDATES
12.2.2
-
APPS.BOM_CSTRUSJA_XMLP_PKG dependencies on CST_COST_UPDATES
12.1.1
-
APPS.INV_INVTRDST_XMLP_PKG dependencies on CST_COST_UPDATES
12.1.1
-
APPS.BOM_CSTRUSJA_XMLP_PKG dependencies on CST_COST_UPDATES
12.2.2
-
APPS.BOM_CSTRUSTA_XMLP_PKG dependencies on CST_COST_UPDATES
12.2.2
-
APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on CST_COST_UPDATES
12.2.2
-
VIEW: APPS.CST_XLA_COST_UPDATES_REF_V
12.2.2
-
Table: CST_STANDARD_COSTS
12.1.1
owner:BOM, object_type:TABLE, fnd_design_data:BOM.CST_STANDARD_COSTS, object_name:CST_STANDARD_COSTS, status:VALID, product: BOM - Bills of Material , description: Standard cost history , implementation_dba_data: BOM.CST_STANDARD_COSTS ,
-
VIEW: BOM.CST_COST_UPDATES#
12.2.2
owner:BOM, object_type:VIEW, object_name:CST_COST_UPDATES#, status:VALID,
-
VIEW: APPS.CST_XLA_COST_UPDATES_REF_V
12.1.1
-
Table: CST_STANDARD_COSTS
12.2.2
owner:BOM, object_type:TABLE, fnd_design_data:BOM.CST_STANDARD_COSTS, object_name:CST_STANDARD_COSTS, status:VALID, product: BOM - Bills of Material , description: Standard cost history , implementation_dba_data: BOM.CST_STANDARD_COSTS ,
-
APPS.INV_INVTRDST_XMLP_PKG SQL Statements
12.1.1
-
APPS.INV_INVTRDST_XMLP_PKG SQL Statements
12.2.2
-
SYNONYM: APPS.CST_COST_UPDATES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CST_COST_UPDATES, status:VALID,
-
SYNONYM: APPS.CST_COST_UPDATES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CST_COST_UPDATES, status:VALID,
-
APPS.BOM_CSTRUSIA_XMLP_PKG dependencies on MFG_LOOKUPS
12.1.1
-
APPS.BOM_CSTRUSIW_XMLP_PKG dependencies on MFG_LOOKUPS
12.1.1
-
VIEW: APPS.CSTBV_ITEM_STD_COST_UPDATES
12.2.2
-
VIEW: APPS.CSTBV_ITEM_STD_COST_UPDATES
12.1.1
-
VIEW: APPS.CST_XLA_INV_CU_V
12.1.1
-
VIEW: APPS.CST_XLA_INV_CU_V
12.2.2
-
VIEW: APPS.CSTFV_ITM_STD_CST_UPD_ELM_HST
12.1.1
-
VIEW: BOM.CST_COST_UPDATES#
12.2.2
-
TABLE: BOM.CST_COST_UPDATES
12.1.1
owner:BOM, object_type:TABLE, fnd_design_data:BOM.CST_COST_UPDATES, object_name:CST_COST_UPDATES, status:VALID,
-
VIEW: APPS.CSTBV_ITM_STD_CST_UPD_ELM_HST
12.1.1
-
VIEW: APPS.CSTBV_ITM_STD_CST_UPD_ELM_HST
12.2.2
-
VIEW: APPS.WIPFV_MFG_COST_UPDATE_TXNS
12.1.1
-
VIEW: APPS.CSTFV_ITEM_STD_COST_UPDATES
12.1.1
-
APPS.BOM_CSTRUSIA_XMLP_PKG dependencies on MFG_LOOKUPS
12.2.2
-
APPS.BOM_CSTRUSIW_XMLP_PKG dependencies on MFG_LOOKUPS
12.2.2
-
VIEW: APPS.CSTFV_ITM_STD_CST_UPD_ELM_HST
12.2.2
-
View: CST_XLA_COST_UPDATES_REF_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BOM.CST_XLA_COST_UPDATES_REF_V, object_name:CST_XLA_COST_UPDATES_REF_V, status:VALID, product: BOM - Bills of Material , description: Standard Cost update sources , implementation_dba_data: APPS.CST_XLA_COST_UPDATES_REF_V ,
-
Table: CST_ELEMENTAL_COSTS
12.2.2
owner:BOM, object_type:TABLE, fnd_design_data:BOM.CST_ELEMENTAL_COSTS, object_name:CST_ELEMENTAL_COSTS, status:VALID, product: BOM - Bills of Material , description: Standard elemental cost history , implementation_dba_data: BOM.CST_ELEMENTAL_COSTS ,
-
TABLE: BOM.CST_COST_UPDATES
12.2.2
owner:BOM, object_type:TABLE, fnd_design_data:BOM.CST_COST_UPDATES, object_name:CST_COST_UPDATES, status:VALID,
-
View: CST_XLA_COST_UPDATES_REF_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BOM.CST_XLA_COST_UPDATES_REF_V, object_name:CST_XLA_COST_UPDATES_REF_V, status:VALID, product: BOM - Bills of Material , description: Standard Cost update sources , implementation_dba_data: APPS.CST_XLA_COST_UPDATES_REF_V ,
-
VIEW: APPS.CSTFV_ITEM_STD_COST_UPDATES
12.2.2
-
VIEW: APPS.WIPFV_MFG_COST_UPDATE_TXNS
12.2.2