Search Results cm_scst_led




Overview
Explore in AI Chat

Overview

The CM_SCST_LED table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the Standard Costs Ledger, providing a permanent, auditable record of all standard cost calculations performed for manufactured items. Rows are systematically inserted into this table during the cost rollup process, which is a critical periodic activity for calculating and updating product costs. The table's primary role is to serve as a ledger, capturing the detailed formula, routing, and cost component data used in each calculation, thereby ensuring traceability and supporting cost analysis and variance reporting.

Key Information Stored

The table stores a comprehensive snapshot of a costed item's manufacturing definition and its calculated costs at a point in time. While the full column list is not detailed in the provided metadata, the foreign key relationships indicate it holds several critical data points. These include the item identifier (ITEM_ID), the warehouse code (WHSE_CODE), and the specific resources (RESOURCES) used in its routing. It also stores unit of measure information for the formula product (FORM_PROD_UM), item fixed material quantity (ITEM_FMQTY_UM), and resource usage (USAGE_UM). A key column is RUDTL_ID, which serves as the table's primary key. Crucially, the table maintains a link to detailed component cost breakdowns via the CMPNTCOST_ID foreign key to CM_CMPT_DTL.

Common Use Cases and Queries

The primary use case for CM_SCST_LED is historical cost analysis and troubleshooting. Analysts query this ledger to review the exact cost structure of a product as it was calculated in a specific cost rollup, compare costs across different rollup periods to identify trends, and investigate cost variances. A typical query would join to item and resource master tables to retrieve descriptive information. For example, to find the latest standard cost for an item:

Another common pattern is drilling into cost components by joining to CM_CMPT_DTL to analyze material, resource, and overhead elements that constitute the total rolled-up cost stored in this ledger.

Related Objects

The CM_SCST_LED table is centrally connected to several master and transactional tables within the GMF and Process Manufacturing schema, as documented by its foreign keys. Key relationships include:

  • CM_CMPT_DTL: Joined via CM_SCST_LED.CMPNTCOST_ID = CM_CMPT_DTL.CMPNTCOST_ID. This is the most direct link to the detailed cost component breakdowns.
  • IC_ITEM_MST / IC_ITEM_MST_B: Joined via CM_SCST_LED.ITEM_ID. Provides the item master information for the costed product.
  • CR_RSRC_MST / CR_RSRC_MST_B: Joined via CM_SCST_LED.RESOURCES. Provides master data for manufacturing resources used in the routing.
  • IC_WHSE_MST: Joined via CM_SCST_LED.WHSE_CODE. Identifies the costing warehouse.
  • SY_UOMS_MST: Joined three times for different units of measure (FORM_PROD_UM, ITEM_FMQTY_UM, USAGE_UM). Provides the unit of measure descriptions and conversion data.