Search Results cm_rlup_ctl




Overview
Explore in AI Chat

Overview

The CM_RLUP_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 is specifically designed to manage the Cost Rollup Process, a critical operation in OPM (Oracle Process Manufacturing) for calculating rolled-up costs of manufactured items through the product structure. The table functions as an interface between the user and the background rollup engine, enabling users to initiate runs, monitor their status in real-time, review historical execution details, and, if necessary, issue commands to abort an in-progress rollup. Its existence is pivotal for ensuring the cost rollup, a resource-intensive batch process, can be managed and audited effectively.

Key Information Stored

The table stores metadata and control parameters for each rollup execution. The primary key, ROLLUP_ID, uniquely identifies each run. Critical columns include the COST_MTHD_CODE, which links to the costing method (CM_MTHD_MST), and the CALENDAR_CODE and PERIOD_CODE, which together identify the accounting period for the cost calculation and reference the calendar details table (CM_CLDR_DTL). Other essential columns would typically encompass status flags (e.g., process phase, completion status), timestamps for start and end times, the user who initiated the run, and control flags that allow a user to signal the process to stop. The structure facilitates tracking the rollup from submission through to completion or failure.

Common Use Cases and Queries

The primary use case is monitoring and controlling active or recent cost rollup jobs. A common query involves checking the status of recent runs to identify any that are stalled or have errors. For example:

  • SELECT rollup_id, cost_mthd_code, calendar_code, period_code, status, requested_by, start_date FROM gmf.cm_rlup_ctl WHERE status NOT IN ('COMPLETE', 'CANCELLED') ORDER BY start_date DESC;

Another critical operation is forcing an abort by updating a specific control column in the table for a given ROLLUP_ID, which the background process polls. Reporting on historical rollup performance and frequency for specific cost methods or periods is also a standard practice, aiding in period-end closing analysis and process auditing.

Related Objects

CM_RLUP_CTL sits at the center of a network of related cost rollup tables. It has a direct foreign key relationship with CM_MTHD_MST (costing methods) and CM_CLDR_DTL (calendar periods). Furthermore, it is referenced as a parent table by several key detail tables: CM_RLUP_ITM stores the individual items processed in each rollup, CM_RLUP_MSG likely holds process messages or logs for the run, and CM_CMPT_DTL (component details) links to it via the ROLLUP_REF_NO column to associate component costs with a specific rollup execution. This hierarchy ensures all data generated by a cost rollup is traceable back to a single control record.

  • 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 , 

  • Table: CM_RLUP_ITM 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_RLUP_ITM,  object_name:CM_RLUP_ITM,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Contains the list of items for which Cost Rollup is to be run. Will have rows only for those rollup runs that are submitted as List of Items Rollup.Regarding removal of delete_mark column between 4.1 and 11.0 releases. - OPM only selects o ,  implementation_dba_data: GMF.CM_RLUP_ITM , 

  • 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_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_ITM 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_RLUP_ITM,  object_name:CM_RLUP_ITM,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Contains the list of items for which Cost Rollup is to be run. Will have rows only for those rollup runs that are submitted as List of Items Rollup.Regarding removal of delete_mark column between 4.1 and 11.0 releases. - OPM only selects o ,  implementation_dba_data: GMF.CM_RLUP_ITM , 

  • Table: CM_CLDR_DTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CLDR_DTL,  object_name:CM_CLDR_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Costing Calendar Details ,  implementation_dba_data: GMF.CM_CLDR_DTL , 

  • Table: CM_CMPT_DTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CMPT_DTL,  object_name:CM_CMPT_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost Component Details ,  implementation_dba_data: GMF.CM_CMPT_DTL , 

  • Table: CM_CMPT_DTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CMPT_DTL,  object_name:CM_CMPT_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Cost Component Details ,  implementation_dba_data: GMF.CM_CMPT_DTL , 

  • Table: CM_CLDR_DTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_CLDR_DTL,  object_name:CM_CLDR_DTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Costing Calendar Details ,  implementation_dba_data: GMF.CM_CLDR_DTL , 

  • Table: CM_MTHD_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_MTHD_MST,  object_name:CM_MTHD_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Item Cost Methods - Cost methods are defined by the user. Cost calculation types for raw material and product costs are also specified for Actual Costing Methods. ,  implementation_dba_data: GMF.CM_MTHD_MST , 

  • Table: CM_MTHD_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.CM_MTHD_MST,  object_name:CM_MTHD_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Item Cost Methods - Cost methods are defined by the user. Cost calculation types for raw material and product costs are also specified for Actual Costing Methods. ,  implementation_dba_data: GMF.CM_MTHD_MST ,