Search Results cst_standard_costs




Overview
Explore in AI Chat

Overview

The CST_STANDARD_COSTS table is a core data repository within the Oracle E-Business Suite Bills of Material (BOM) module, specifically designed for standard costing implementations. Its primary role is to maintain a detailed historical record of standard costs for inventory items within a manufacturing organization. This table is fundamental to the cost accounting lifecycle, capturing the results of standard cost updates and providing a permanent audit trail. It enables organizations to track cost evolution over time, analyze cost variances, and support financial reporting and inventory valuation processes. The table's existence is critical for maintaining data integrity and supporting rollback capabilities in the event of a cost update error.

Key Information Stored

The table stores a snapshot of an item's standard cost components as of a specific cost update. While the full column list is extensive, the structure centers on linking an item's cost to a specific update transaction. The primary key, enforced by the CST_STANDARD_COSTS_PK index, uniquely identifies a record through the combination of COST_UPDATE_ID, INVENTORY_ITEM_ID, and ORGANIZATION_ID. This design ensures one cost record per item per update per organization. Key columns include the LAST_COST_UPDATE_ID, which links to the previous cost record, creating a chain of historical cost data. Other significant columns typically store the item cost itself (e.g., ITEM_COST), material, resource, overhead, and outside processing cost elements, and the effective date of the cost.

Common Use Cases and Queries

The table is central to historical cost analysis and audit reporting. A common use case is tracing the standard cost history of a specific item to understand the impact of engineering changes or supplier price fluctuations. Another critical scenario involves reconciling inventory valuation reports by comparing current on-hand value against the historical costs applied to transactions. A typical query retrieves the complete cost history for an item:

  • SELECT cs.cost_update_id, cs.item_cost, cu.update_date FROM bom.cst_standard_costs cs, bom.cst_cost_updates cu WHERE cs.inventory_item_id = :p_item_id AND cs.organization_id = :p_org_id AND cs.cost_update_id = cu.cost_update_id ORDER BY cu.update_date DESC;

This data is also essential for generating reports on cost change summaries between two update periods or investigating period-end variances by comparing frozen standard costs against the costs in effect when transactions occurred.

Related Objects

CST_STANDARD_COSTS has integral relationships with other core costing tables. As indicated by the foreign keys, it is directly linked to the CST_COST_UPDATES table twice: via COST_UPDATE_ID (identifying the update that created this record) and LAST_COST_UPDATE_ID (identifying the immediately prior cost record). This creates a formal relationship to the transaction header information. The table is also closely related to CST_ITEM_COSTS, which typically holds the current, active standard costs, whereas CST_STANDARD_COSTS holds the historical snapshots. Key item and organization information is sourced from MTL_SYSTEM_ITEMS_B and HR_ORGANIZATION_UNITS, respectively. Processes and reports often join through these relationships to provide complete contextual data.