Search Results cm_cupd_ctl




Overview
Explore in AI Chat

Overview

The CM_CUPD_CTL table is a core control and communication mechanism within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for managing and monitoring the Cost Update Process, a critical background operation in Oracle Process Manufacturing (OPM). This table facilitates asynchronous interaction between the user and the long-running cost update job. Administrators and cost accountants use it to initiate runs, review the status and history of past executions, and, when necessary, issue commands to abort an active process, ensuring operational control over this vital financial calculation.

Key Information Stored

The table's primary function is to store control parameters and runtime status for each cost update execution. Its primary key, CUPROC_ID, uniquely identifies each process run. Key columns include COST_MTHD_CODE, which links to the costing method (CM_MTHD_MST), and CALENDAR_CODE with PERIOD_CODE, which together define the accounting period for the update and reference the financial calendar (CM_CLDR_DTL). Other critical columns likely present, inferred from its purpose, would store the process status (e.g., 'RUNNING', 'COMPLETE', 'ERROR'), request and completion timestamps, the requesting user ID, and a flag or column to signal an abort request from the user interface. This structure allows the concurrent program to read its parameters and update its progress while the UI polls the same record for status display.

Common Use Cases and Queries

The primary use case is monitoring and controlling the Cost Update Process. A common operational query checks for active or recently completed runs to assess system load or verify a submission. For example: SELECT cuproc_id, cost_mthd_code, calendar_code, period_code, status, requested_date
FROM gmf.cm_cupd_ctl
WHERE requested_date > SYSDATE - 1
ORDER BY requested_date DESC; Another critical action is forcing an abort, which typically involves updating a specific column (e.g., ABORT_FLAG) to 'Y' for a running process ID. Reporting on process history to audit cost update frequency and performance over time is also a standard practice, often joining to CM_MTHD_MST for the method description and CM_CLDR_DTL for period details.

Related Objects

  • CM_CUPD_MSG: This table holds detailed log or message data for each cost update run. It has a foreign key relationship, where CM_CUPD_MSG.CUPROC_ID references CM_CUPD_CTL.CUPROC_ID, providing a drill-down from control to detailed messages.
  • CM_MTHD_MST: The Costing Method master table, referenced via the foreign key on CM_CUPD_CTL.COST_MTHD_CODE, defining the costing methodology used in the update.
  • CM_CLDR_DTL: The Financial Calendar Details table, referenced via foreign keys on CM_CUPD_CTL.CALENDAR_CODE and PERIOD_CODE, defining the accounting period for the cost update.