Search Results cuproc_id




Overview
Explore in AI Chat

Overview

The CM_CUPD_MSG table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the central repository for error messages generated by the Cost Update process. This process is critical for maintaining accurate and current standard costs for manufactured items within Oracle Process Manufacturing (OPM). The table's primary role is to log unique process errors, ensuring no duplicate messages are recorded, thereby providing a clean audit trail. The stored messages enable OPM users and financial analysts to systematically evaluate the performance and accuracy of each cost update run, facilitating troubleshooting and process validation.

Key Information Stored

The table's structure is designed to link error messages to specific process executions and sequence them for review. While the full column list is not detailed in the provided metadata, the defined constraints reveal the essential key columns. The CUPROC_ID column is a foreign key that uniquely identifies the controlling record for a specific Cost Update process run in the parent CM_CUPD_CTL table. The LINE_NO column sequences the error messages generated within that single process run, forming a composite primary key with CUPROC_ID. Typical data stored includes the error message text, a timestamp, the severity of the error, and potentially identifiers for the specific transaction, item, or cost element that caused the failure during the update.

Common Use Cases and Queries

The primary use case is post-process analysis and debugging of the Cost Update process. Users query this table to identify failures that prevented costs from updating correctly for specific items or across the entire run. A common reporting pattern involves joining to the control table to filter by process date or status.

  • Sample Query to Review Errors for a Process Run:
    SELECT msg.line_no, msg.message_text, ctl.process_date
    FROM gmf.cm_cupd_msg msg, gmf.cm_cupd_ctl ctl
    WHERE msg.cuproc_id = ctl.cuproc_id
    AND ctl.cuproc_id = :process_id
    ORDER BY msg.line_no;
  • Use Case for Cleanup: Administrators may archive or purge records from CM_CUPD_MSG for completed process runs after a defined retention period to manage table growth.

Related Objects

The CM_CUPD_MSG table has a direct and singular parent-child relationship within the Cost Update process schema, as documented by its foreign key constraint.

  • CM_CUPD_CTL (Control Table): This is the primary related table. Every record in CM_CUPD_MSG must correspond to a master process run record in CM_CUPD_CTL. The tables are joined on the CM_CUPD_MSG.CUPROC_ID = CM_CUPD_CTL.CUPROC_ID column. The control table provides contextual metadata such as the process run date, parameters, and overall status.
  • Table: CM_CUPD_MSG 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CUPD_MSG,  object_name:CM_CUPD_MSG,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost Update process error messages table - error messages found during the process. No duplicate error messages are written. These error messages will be used by the OPM user to evaluate performance and accuracy of the process and, if nec ,  implementation_dba_data: GMF.CM_CUPD_MSG , 

  • Table: CM_CUPD_CTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CUPD_CTL,  object_name:CM_CUPD_CTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost Update Process Control Table - allows the OPM user to communicate with the Cost Update Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort. ,  implementation_dba_data: GMF.CM_CUPD_CTL , 

  • Table: CM_CUPD_MSG 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CUPD_MSG,  object_name:CM_CUPD_MSG,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost Update process error messages table - error messages found during the process. No duplicate error messages are written. These error messages will be used by the OPM user to evaluate performance and accuracy of the process and, if nec ,  implementation_dba_data: GMF.CM_CUPD_MSG , 

  • Table: CM_CUPD_CTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CUPD_CTL,  object_name:CM_CUPD_CTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost Update Process Control Table - allows the OPM user to communicate with the Cost Update Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort. ,  implementation_dba_data: GMF.CM_CUPD_CTL ,