Search Results cm_rlup_itm




Overview
Explore in AI Chat

Overview

The CM_RLUP_ITM table is a core data object within the GMF (Process Manufacturing Financials) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a transactional staging table specifically for the cost rollup process. Its primary function is to store the list of individual inventory items for which a detailed cost rollup calculation is requested. This table only contains data when a cost rollup is explicitly submitted as a "List of Items Rollup," as opposed to a rollup for an entire cost group or all items. The table's existence is critical for managing targeted, item-specific cost recalculations within Oracle Process Manufacturing's (OPM) financial costing architecture.

Key Information Stored

The table's structure is designed to link specific items to a parent rollup control transaction. The primary key is a composite of ROLLUP_ID and ITEM_ID, ensuring a unique record for each item included in a given rollup request. The ROLLUP_ID column is a foreign key that ties each item entry back to its master control record in the CM_RLUP_CTL table, which defines the overall rollup batch parameters. The ITEM_ID column stores the internal identifier (typically from INV_ITEM_ID in MTL_SYSTEM_ITEMS_B) for the inventory item slated for cost recalculation. Historical documentation notes the removal of a DELETE_MARK column between earlier releases, indicating the table's data is now considered transient for the duration of the rollup process.

Common Use Cases and Queries

The primary use case is the execution and audit of item-specific cost rollups. A Process Manufacturing cost accountant would interact with this table indirectly through the GMF user interface to submit a rollup for a defined list of items. Technically, common queries involve identifying all items pending or processed in a specific rollup batch or troubleshooting rollup errors for particular items. A typical reporting query would join to the item master and rollup control tables:

  • SELECT ctl.rollup_no, msib.segment1 item_code, itm.* FROM gmf.cm_rlup_itm itm JOIN gmf.cm_rlup_ctl ctl ON itm.rollup_id = ctl.rollup_id JOIN inv.mtl_system_items_b msib ON itm.item_id = msib.inventory_item_id WHERE ctl.rollup_no = '&ROLLUP_NUMBER';

This table is also central to any custom program or interface designed to automate the submission of cost rollups for a dynamic list of items.

Related Objects

CM_RLUP_ITM has a direct and essential relationship with the CM_RLUP_CTL table, which acts as its parent control entity. The documented foreign key relationship is:

  • Foreign Key to CM_RLUP_CTL: The ROLLUP_ID column in CM_RLUP_ITM references the ROLLUP_ID column in the CM_RLUP_CTL table. This relationship ensures every item listed for rollup is part of a valid, submitted rollup batch. The CM_RLUP_CTL table stores the overarching parameters like the cost type, cost group, legal entity, and status of the rollup job.

While not explicitly listed in the provided metadata, the ITEM_ID column inherently relates to the MTL_SYSTEM_ITEMS_B table to resolve item numbers and descriptions. The table is also intrinsically linked to the core GMF costing engine and the underlying cost rollup concurrent program logic.

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