Results for “cm_cmpt_mst_tl”

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

Overview

CM_CMPT_MST_TL is the translation (TL) table for the Cost Component Master entity within the GMF – Process Manufacturing Financials product family. In Oracle E-Business Suite, cost components represent the building blocks used to assemble cost build-ups, rollups, and cost breakdowns for process-manufactured items. Because Oracle EBS supports multi-language deployments, every translatable descriptive attribute is stored in a companion TL table keyed by language, while language-independent attributes remain in the base table (CM_CMPT_MST_B). This table holds the translated descriptions of cost component classes.

The object resides in the GMF schema and is documented as VALID in ETRM 12.2.2. Its heuristic Data Vault classification, mined from the foreign-key structure, is standalone, meaning it does not participate in a parent-child FK chain within the mined model. From a modeling perspective, this classifies the table as a satellite-like construct: its primary key combines the parent entity identifier with a language discriminator, and it carries descriptive, versioned-by-language text rather than transactional measures. In Data Vault terms, COST_CMPNTCLS_ID functions as the hub reference and LANGUAGE as the satellite driving key.

Key Information Stored

The table contains nine documented columns. The primary key, CM_CMPT_MST_TL_PK, is a composite surrogate key over (COST_CMPNTCLS_ID, LANGUAGE). The same column pair also constitutes the sole documented unique index, making it the business-key candidate that enforces one translated row per cost component class per installed language.

• COST_CMPNTCLS_ID – Surrogate identifier of the cost component class; the join back to the base table and the hub reference in the composite key.
• LANGUAGE – Installed language code; the second component of the primary key and the discriminator that isolates each translation row.
• SOURCE_LANG – The language from which the translated description was derived, used by the translation framework to detect stale or missing translations.
• COST_CMPNTCLS_DESC#1 – The translated description of the cost component class; the primary user-facing attribute exposed by this table.
• CREATION_DATE, CREATED_BY – Standard WHO audit columns capturing row creation metadata.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard WHO audit columns capturing the most recent modification and the login context of the updater.

The WHO columns follow the standard EBS audit convention and are maintained automatically by the application's audit-attribute infrastructure; they should not be populated by custom code.

Common Use Cases and Queries

The most frequent requirement is reporting cost component class descriptions in the user's session language while retaining the base table's language-independent attributes. A typical query joins the TL table to the base entity on COST_CMPNTCLS_ID and filters by LANGUAGE:

• Language-specific lookup: SELECT b.cost_cmpntcls_id, t.cost_cmpntcls_desc#1 FROM cm_cmpt_mst_b b, cm_cmpt_mst_tl t WHERE b.cost_cmpntcls_id = t.cost_cmpntcls_id AND t.language = USERENV('LANG')
• Multi-language comparison: Group by COST_CMPNTCLS_ID and pivot on LANGUAGE to identify components whose translations diverge or are missing in a given language.
• Translation completeness audit: Compare row counts in the TL table per LANGUAGE against the base table to detect untranslated cost component classes, and inspect SOURCE_LANG to flag rows where the source and installed languages differ.
• Change tracking: Filter on LAST_UPDATE_DATE to extract recently re-translated descriptions for downstream data warehouse or master data governance feeds.

Because the table is keyed by language, reports that omit the LANGUAGE predicate will return one row per installed language and produce duplicated cost component descriptions.

Related Objects

The metadata documents no explicit foreign keys, consistent with its standalone Data Vault classification, but the following objects are the most significant participants in the surrounding model:

• CM_CMPT_MST_B – The base (non-translated) Cost Component Master table; joins on COST_CMPNTCLS_ID and supplies language-independent attributes.
• CM_CMPT_MST_TL_PK – The composite unique index over (COST_CMPNTCLS_ID, LANGUAGE) that enforces one translation row per class per language.
• FND_LANGUAGES – Reference table validating the LANGUAGE and SOURCE_LANG values against installed languages.
• FND_APPLICATION / FND_PRODUCT_INSTALLATIONS – Metadata objects that govern GMF schema ownership and translation framework registration.
• CM_CMPT_MST_VL – Where present, the translated view that unions base and TL columns to present a single logical row per cost component class.

Cost component classes defined here are consumed by the process manufacturing costing programs that build item cost rollups, so downstream costing and valuation reports depend indirectly on the accuracy of the descriptions held in this table.