Results for “cm_cmpt_mst”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CM_CMPT_MST is the Cost Component Master table in the Oracle EBS Process Manufacturing Financials (GMF) module. It serves as the central repository for defining cost components, which are the elemental building blocks used by Oracle Process Manufacturing's costing engine to accumulate, classify, and roll up manufacturing costs. Each row in CM_CMPT_MST represents a distinct cost component — such as material, labor, overhead, or resource-related costs — that can be assigned to product costs, resources, operations, and general ledger mapping rules throughout the GMF and OPM (Oracle Process Manufacturing) application stack.

Because cost components pervade nearly every costing, burden, adjustment, and GL-mapping transaction in process manufacturing, this table acts as a reference or master entity that many transactional and configuration tables depend upon. From a Data Vault modeling perspective, the FK structure suggests CM_CMPT_MST behaves as a hub-leaning table: it is the anchor referenced by at least thirteen downstream tables, while itself referencing only two parent tables (CM_CMPT_GRP and CM_TEXT_HDR). This pattern — a widely referenced master with a small number of upstream lookups — is characteristic of a hub entity in a Data Vault model.

Key Information Stored

The primary key of CM_CMPT_MST is defined by the constraint CM_CMPT_MST_PK, which is keyed on the column COST_CMPNTCLS_ID. This is the surrogate identifier used by all dependents to reference a given cost component. Beyond the key, the documented metadata identifies the following notable columns:

• COST_CMPNTCLS_ID — the primary key and surrogate identifier for the cost component class; used in every downstream FK relationship.
• CMPNT_GROUP — a grouping attribute that links the component to CM_CMPT_GRP, allowing cost components to be organized into logical cost component groups.
• TEXT_CODE — a reference to CM_TEXT_HDR, providing descriptive text or multilanguage text used to label or describe the cost component.

Because the excerpt does not enumerate the full column list, the above three columns are the only ones grounded in the documented metadata. In practice, additional descriptive and status attributes accompany COST_CMPNTCLS_ID as business-key candidates; however, no alternative unique indexes are documented in the supplied metadata. COST_CMPNTCLS_ID therefore serves as both surrogate primary key and the de facto business identifier used throughout the model.

Common Use Cases and Queries

Typical uses of CM_CMPT_MST include building cost component hierarchies for product costing, joining components to resources and operations, and driving GL account mapping. A simple lookup to return all cost components with their groups and descriptive text would follow this pattern:

• SELECT m.COST_CMPNTCLS_ID, m.CMPNT_GROUP, m.TEXT_CODE FROM CM_CMPT_MST m;
• SELECT m.COST_CMPNTCLS_ID, g.CMPNT_GROUP, t.TEXT FROM CM_CMPT_MST m JOIN CM_CMPT_GRP g ON m.CMPNT_GROUP = g.CMPNT_GROUP JOIN CM_TEXT_HDR t ON m.TEXT_CODE = t.TEXT_CODE;

Reporting scenarios frequently require identifying every downstream object tied to a component, for example joining CM_CMPT_MST to CM_ADJS_DTL or CM_BRDN_DTL on COST_CMPNTCLS_ID to trace adjustments and burdens. Cost rollup queries join CM_CMPT_MST to CR_RSRC_MST and FM_OPRN_DTL to attribute resource and operation costs correctly. GL integration queries join to GL_ACCT_MAP and GL_ALOC_BAS to verify that each component maps to a valid account.

Related Objects

CM_CMPT_MST participates in a broad set of foreign-key relationships. The most significant referenced and referencing objects are:

• CM_CMPT_GRP — parent table joined via CM_CMPT_MST.CMPNT_GROUP; defines cost component groups.
• CM_TEXT_HDR — parent text master joined via CM_CMPT_MST.TEXT_CODE.
• CM_CMPT_DTL — child detail table linked on COST_CMPNTCLS_ID.
• CM_CMPT_MTL — links materials to component classes via MTL_CMPNTCLS_ID.
• CM_ACST_LED and CM_ADJS_DTL and CM_BRDN_DTL — actual cost ledger, adjustment, and burden detail tables referencing COST_CMPNTCLS_ID.
• CR_RSRC_MST — resources reference the component class via COST_CMPNTCLS_ID.
• FM_OPRN_DTL and PM_OPRN_DTL — operation detail tables in process and discrete manufacturing that reference COST_CMPNTCLS_ID.
• GL_ACCT_MAP, GL_ALOC_BAS, GL_ITEM_DTL, GL_PLCY_MST — general ledger mapping, allocation basis, item detail, and policy master tables that join on COST_CMPNTCLS_ID or CMPNTCLS_ID.
• PO_COST_MST — purchasing cost master referencing CMPNTCLS_ID.