Search Results actrans_id

Overview

The CM_ACST_LED table is a core transactional ledger within Oracle E-Business Suite Process Manufacturing Financials (GMF). It functions as the central repository for all actual costing transactions. This table is critical for capturing and storing detailed cost data that originates from various manufacturing and procurement operations, specifically from production batch material details (PM_MATL_DTL), process operation resource details (PM_OPRN_DTL), and purchase order receipts. As a ledger, it provides the granular transaction-level foundation necessary for performing accurate actual cost calculations, cost analysis, and financial reconciliation within a process manufacturing environment, distinguishing it from standard costing ledgers.

Key Information Stored

The table's primary key is ACTRANS_ID, which uniquely identifies each costing transaction. Its structure is defined by numerous foreign key relationships that link it to master and control data across the application. Key columns include ACPROC_ID, linking to the actual costing process control table (CM_ACPR_CTL); COST_ANALYSIS_CODE, referencing cost analysis definitions (CM_ALYS_MST); and CALENDAR_CODE with PERIOD_CODE, tying transactions to the financial calendar (CM_CLDR_DTL). It also stores ITEM_ID and WHSE_CODE to identify the specific item and warehouse involved, and COST_CMPNTCLS_ID and COST_MTHD_CODE to define the cost component and costing method applied to the transaction. This design ensures every financial movement is fully characterized and traceable to its source.

Common Use Cases and Queries

This table is primarily queried for cost analysis, period-end closing activities, and troubleshooting cost discrepancies. A common use case is tracing the detailed cost impact of a specific production batch or purchase order. For reporting, analysts often join CM_ACST_LED to item and organization master tables to generate detailed actual cost reports. A typical query pattern involves filtering by period, item, and warehouse, and summing transaction quantities and amounts by cost component.

• Sample Query (Transaction Summary by Item/Period):
  SELECT cal.calendar_code, cal.period_code, im.item_no, im.description, led.cost_cmpntcls_id, SUM(led.trans_qty), SUM(led.trans_amt)
  FROM gmf.cm_acst_led led,
  gmf.cm_cldr_dtl cal,
  ic_item_mst im
  WHERE led.calendar_code = cal.calendar_code
  AND led.period_code = cal.period_code
  AND led.item_id = im.item_id
  AND cal.period_code = 'JAN-24'
  GROUP BY cal.calendar_code, cal.period_code, im.item_no, im.description, led.cost_cmpntcls_id
  ORDER BY im.item_no;

Related Objects

CM_ACST_LED has extensive dependencies, as shown by its foreign keys. It is a child table to several master data tables, including CM_ACPR_CTL (process control), CM_ALYS_MST (cost analysis), CM_CLDR_DTL (calendar), CM_CMPT_MST (cost component), and CM_MTHD_MST (costing method). It also references foundational inventory tables IC_ITEM_MST and IC_WHSE_MST. The table is intrinsically linked to the transaction source tables PM_MATL_DTL and PM_OPRN_DTL, from which its data is populated. Understanding these relationships is essential for any data extraction, custom reporting, or audit trail analysis related to Process Manufacturing actual costs.