Search Results cm_adjs_dtl




Overview
Explore in AI Chat

Overview

The CM_ADJS_DTL table is a core transactional data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the detailed repository for actual cost adjustments, a critical function in process manufacturing cost accounting. This table stores the granular line-item details for every cost adjustment transaction entered into the system. Its primary role is to maintain a precise, auditable record of adjustments made to inventory costs, enabling accurate period-end costing, variance analysis, and financial reporting. The integrity of data in this table is essential for reflecting true inventory valuation and cost of goods sold in the general ledger.

Key Information Stored

The table's structure is designed to uniquely identify and quantify a cost adjustment for a specific item in a specific context. The primary key columns define this unique combination: ITEM_ID, WHSE_CODE, CALENDAR_CODE, PERIOD_CODE, COST_MTHD_CODE, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE, and COST_ADJUST_ID. Key transactional columns include ADJUST_QTY_UM (the unit of measure for the adjusted quantity) and the associated REASON_CODE and TEXT_CODE, which provide narrative context for the adjustment. The table's foreign key relationships indicate it stores identifiers linking to master data for the item, warehouse, cost calendar, cost method, cost component class, and cost analysis code, ensuring referential integrity across the costing subsystem.

Common Use Cases and Queries

This table is central to post-transaction cost management activities. A primary use case is generating detailed audit reports for all cost adjustments performed in a given accounting period, which is crucial for financial audits and internal controls. Analysts query this table to investigate cost variances by item, warehouse, or cost component. A typical reporting query would join CM_ADJS_DTL to master tables like IC_ITEM_MST and CM_CLDR_DTL to produce a human-readable adjustment register. For technical support, queries often isolate adjustments for a specific COST_ADJUST_ID to troubleshoot adjustment batch issues. Data from this table also feeds into reconciliation reports between the GMF cost engine and the Oracle General Ledger.

Related Objects

CM_ADJS_DTL has extensive foreign key relationships, highlighting its position as a central hub for cost adjustment data. Key documented relationships include:

  • CM_ALYS_MST: Joined via COST_ANALYSIS_CODE for cost analysis master data.
  • CM_CLDR_DTL: Joined via CALENDAR_CODE and PERIOD_CODE for cost calendar period validation.
  • CM_CMPT_MST / CM_CMPT_MST_B: Joined via COST_CMPNTCLS_ID for cost component class definition.
  • CM_MTHD_MST: Joined via COST_MTHD_CODE for cost method information.
  • CM_REAS_CDS: Joined via REASON_CODE for the adjustment reason description.
  • IC_ITEM_MST / IC_ITEM_MST_B: Joined via ITEM_ID for item master attributes.
  • IC_WHSE_MST: Joined via WHSE_CODE for warehouse details.
  • SY_UOMS_MST: Joined via ADJUST_QTY_UM for the unit of measure definition.
These relationships enforce business rules and ensure that all adjustments reference valid master data configurations.