Search Results cm_rlup_msg




Overview
Explore in AI Chat

Overview

The CM_RLUP_MSG table is a core data object within the Oracle Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as the central repository for error and inconsistency messages generated during the execution of the Cost Rollup Process. This process is critical for calculating accurate product costs in a manufacturing environment by rolling up component, resource, and overhead costs through the bill of materials. The table's primary role is to provide a detailed audit trail of issues encountered, enabling users to evaluate the process's performance and accuracy, and to take corrective action to ensure data integrity for costing and financial reporting.

Key Information Stored

The table is designed to store discrete error messages linked to specific rollup executions. Its structure is defined by a composite primary key consisting of ROLLUP_ID and LINE_NO. The ROLLUP_ID column is a foreign key that associates each error message with a specific cost rollup run, as recorded in the controlling table, CM_RLUP_CTL. The LINE_NO column sequences multiple messages that may arise from a single rollup process. While the provided metadata does not list all columns, typical columns in such a message table would include a detailed MESSAGE_TEXT or ERROR_DESC field containing the descriptive text of the inconsistency, a MESSAGE_TYPE or SEVERITY indicator, and potentially a reference to the specific transactional data (e.g., item, organization, cost element) that caused the error, enabling efficient troubleshooting.

Common Use Cases and Queries

The primary use case is post-process diagnostics and support. After a cost rollup completes, users or support personnel query this table to identify failures. Common SQL patterns include retrieving all messages for a recent or failed rollup, or filtering for specific error types. For example: SELECT line_no, message_text FROM gmf.cm_rlup_msg WHERE rollup_id = &rollup_id ORDER BY line_no; This data is often leveraged in custom reports or integrated into process monitoring dashboards to track the health and success rate of periodic cost rollup jobs. Analysts use the messages to pinpoint data issues in master data (like missing item costs) or transactional data before re-running the rollup process.

Related Objects

The CM_RLUP_MSG table has a direct and essential relationship with the CM_RLUP_CTL table via a foreign key constraint. CM_RLUP_CTL serves as the master control table for each rollup process instance, storing high-level parameters and status. Therefore, CM_RLUP_MSG is a child detail table to CM_RLUP_CTL. This relationship ensures referential integrity, meaning all error messages are tied to a valid rollup execution ID. The table is intrinsically linked to the core GMF costing engine and its associated programs and APIs that perform the rollup calculation and populate this message log.

  • Table: CM_RLUP_MSG 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_RLUP_MSG,  object_name:CM_RLUP_MSG,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: The Cost Rollup Process Error Message Table will provide the user a list of inconsistencies found during the process. These error messages will be used by the OPM user to evaluate performance and accuracy of the process and, if necessary, t ,  implementation_dba_data: GMF.CM_RLUP_MSG , 

  • Table: CM_RLUP_MSG 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_RLUP_MSG,  object_name:CM_RLUP_MSG,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: The Cost Rollup Process Error Message Table will provide the user a list of inconsistencies found during the process. These error messages will be used by the OPM user to evaluate performance and accuracy of the process and, if necessary, t ,  implementation_dba_data: GMF.CM_RLUP_MSG , 

  • Table: CM_RLUP_CTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_RLUP_CTL,  object_name:CM_RLUP_CTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost Rollup Process Control Table - allows the OPM user to communicate with the Cost Rollup 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_RLUP_CTL , 

  • Table: CM_RLUP_CTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_RLUP_CTL,  object_name:CM_RLUP_CTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost Rollup Process Control Table - allows the OPM user to communicate with the Cost Rollup 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_RLUP_CTL ,