Search Results mtl_cst_actual_cost_details




Overview
Explore in AI Chat

Overview

The MTL_CST_ACTUAL_COST_DETAILS table is a core transactional data repository within Oracle E-Business Suite Inventory (INV) and Cost Management modules. It serves as the definitive ledger for capturing and storing the granular, elemental breakdown of actual costs associated with inventory transactions. Its primary role is to support detailed cost accounting and analysis by recording costs at specific levels (such as item, batch, or lot) and by individual cost element (like material, overhead, or resource). This table is fundamental to the perpetual costing system, enabling precise inventory valuation, cost roll-up calculations, and the generation of critical financial reports.

Key Information Stored

The table's structure is designed to uniquely identify a cost detail record through its primary key, which combines transaction, organizational, and costing dimensions. Key columns include LAYER_ID, which identifies the cost layer; TRANSACTION_ID, linking to the source material transaction in MTL_MATERIAL_TRANSACTIONS; and ORGANIZATION_ID. The critical costing attributes are COST_ELEMENT_ID (foreign key to CST_COST_ELEMENTS) and LEVEL_TYPE, which together define the nature and application level of the cost. The table also stores the associated INVENTORY_ITEM_ID and holds the actual cost amounts. The TRANSACTION_ACTION_ID further categorizes the type of transaction that generated the cost.

Common Use Cases and Queries

This table is essential for troubleshooting cost discrepancies, auditing inventory valuations, and building custom cost reports. A common use case is analyzing the detailed cost composition of a specific item or transaction. For example, to retrieve the elemental cost breakdown for a particular inventory transaction, one might use a query such as:

  • SELECT mcad.cost_element_id, cce.cost_element, mcad.level_type, mcad.actual_cost
  • FROM mtl_cst_actual_cost_details mcad,
  • cst_cost_elements cce
  • WHERE mcad.transaction_id = :p_transaction_id
  • AND mcad.cost_element_id = cce.cost_element_id;

Another frequent scenario involves summarizing total actual costs by item and element for a given cost layer to understand inventory valuation details, often joining with MTL_SYSTEM_ITEMS_B for item descriptions.

Related Objects

MTL_CST_ACTUAL_COST_DETAILS maintains integral relationships with several key EBS tables, as defined by its foreign keys. Its most significant link is to MTL_MATERIAL_TRANSACTIONS, the source of all inventory movement transactions. The COST_ELEMENT_ID column references CST_COST_ELEMENTS, the master table for cost element definitions. Furthermore, it references MTL_SYSTEM_ITEMS_B along with ORGANIZATION_ID to tie costs to specific items. This table is also a primary source for various cost inquiry forms and underlying views within the Cost Management application.