Search Results cm_acpr_ctl




Overview
Explore in AI Chat

Overview

The CM_ACPR_CTL table is a core control and communication mechanism 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 central control table for the Actual Cost Process, a critical background engine responsible for calculating the actual cost of manufactured items in a process manufacturing environment. Its primary role is to facilitate interaction between the user and the running process, allowing for monitoring, review of historical execution data, and administrative intervention when necessary. The table acts as a persistent log and state manager for each execution instance of the cost calculation engine.

Key Information Stored

The table's structure is designed to track the lifecycle and status of each Actual Cost Process run. While a full column list is not provided in the metadata, the primary key is documented as ACPROC_ID, a unique identifier for each process execution instance. Based on its described function, the table likely contains columns to record the process initiation timestamp, the requesting user ID, the organizational and cost book parameters for the run, the current execution status (e.g., RUNNING, COMPLETED, ERROR, PAUSED), completion timestamp, and any user-initiated control flags. These flags would enable functionalities such as forcing the process to a specific state, which is a key administrative capability mentioned in the description.

Common Use Cases and Queries

The primary use case is monitoring and managing the Actual Cost Process. Users and system administrators query this table to assess the system's cost processing activity. Common SQL patterns include checking for currently running processes, reviewing the history of recent runs for audit purposes, and diagnosing failed executions. For example, a query to find incomplete runs might be: SELECT acproc_id, status, requested_by FROM gmf.cm_acpr_ctl WHERE status NOT IN ('COMPLETE', 'ERROR');. Another typical report would list all process runs for a specific cost book within a date range to analyze processing frequency and duration. The ability to "force the process to a" state, as noted in the description, implies there are also update operations performed on this table for administrative control.

Related Objects

As documented in the foreign key relationships, CM_ACPR_CTL is a parent table to several key transactional tables in the GMF cost accounting schema. The ACPROC_ID links each control record to its detailed output. Key child tables include:

  • CM_ACER_MSG: Likely stores error or log messages generated during the cost process execution.
  • CM_ACST_LED: Presumably holds the actual cost ledger entries or summaries resulting from the process.
  • CM_CMPT_DTL: Probably contains the detailed component cost calculations for manufactured items.
These relationships ensure that all cost data produced by a specific execution of the Actual Cost Process is traceable back to its controlling entry in CM_ACPR_CTL, maintaining full auditability and data integrity.