Results for “cm_alys_mst”

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

Overview

CM_ALYS_MST is the Cost Analysis Code Master Table within the Oracle EBS Process Manufacturing Financials (GMF) module. It serves as the central reference table that defines and validates the cost analysis codes used throughout the Process Manufacturing costing and accounting engine. Cost analysis codes classify cost components and cost transactions so that expenses, burdens, adjustments, and cost rollups can be segregated by analytical category — a fundamental requirement for process manufacturing environments where by-products, co-products, and multiple cost buckets must be tracked separately.

From a Data Vault modeling perspective, the metadata's heuristic classification identifies this table as hub-leaning. In practical terms, CM_ALYS_MST behaves as a hub: it holds the durable business key (the cost analysis code) and a small set of descriptive and audit attributes, while the surrounding ledger, detail, and mapping tables act as satellites and links that reference it. This classification is a modeling suggestion rather than a physical implementation constraint.

Key Information Stored

The table contains ten documented columns. The most significant are:

• COST_ANALYSIS_CODE#1 — The business key and the sole unique index candidate, defined by the primary key constraint CM_ALYS_MST_PK. Every downstream costing table references this value.
• COST_ANALYSIS_DESC#1 — The descriptive label presented to users in costing setups, reports, and inquiry screens.
• TEXT_CODE — A foreign key to CM_TEXT_HDR, linking the analysis code to extended descriptive text stored in the common text header table.
• TRANS_CNT — A transaction counter typically used for concurrency control and reference-count validation.
• DELETE_MARK — An internal soft-delete flag; rows are logically deactivated rather than physically removed.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each definition, when, and under which login session.

The primary key is surrogate in form (CM_ALYS_MST_PK) but is enforced against COST_ANALYSIS_CODE, which is simultaneously the business-key candidate. No separate hidden surrogate identifier is documented.

Common Use Cases and Queries

Cost accountants and implementation teams query this table to validate the cost analysis codes that drive process manufacturing cost rollups, burden application, and GL account mapping. Typical patterns include:

• Listing all active analysis codes for setup review or migration: SELECT COST_ANALYSIS_CODE, COST_ANALYSIS_DESC FROM GMF.CM_ALYS_MST WHERE DELETE_MARK = 0;
• Resolving the extended description for an analysis code by joining to CM_TEXT_HDR on TEXT_CODE.
• Impact analysis before deactivating a code — identifying which ledger, burden, or mapping rows reference it across CM_ACST_LED, CM_BRDN_DTL, GMF_BURDEN_ASSOCIATION, and GL_ACCT_MAP.
• Auditing recent changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Reporting cost breakdowns where analysis-code descriptions are used as grouping labels in costing inquiries.

Related Objects

CM_ALYS_MST is heavily referenced. The most significant dependent tables, with their join columns, are:

• CM_TEXT_HDR — parent of the TEXT_CODE foreign key, supplying extended text.
• CM_ACST_LED (COST_ANALYSIS_CODE) — actual cost ledger postings classified by analysis code.
• CM_BRDN_DTL (COST_ANALYSIS_CODE) — burden detail lines.
• CM_ADJS_DTL and CM_CMPT_DTL (COST_ANALYSIS_CODE) — adjustment and component cost details.
• GMF_BURDEN_ASSOCIATION — references the code twice, via SOURCE_ANALYSIS_CODE and TARGET_ANALYSIS_CODE, defining burden transfer rules.
• GL_ACCT_MAP and GL_ITEM_DTL (COST_ANALYSIS_CODE) — cost-to-GL account and item-level mappings.
• FM_ACTV_MST and FM_OPRN_DTL (COST_ANALYSIS_CODE), PM_OPRN_DTL (COST_ANALYSIS_CODE) — activity and operation costing definitions.
• GMD_ACTIVITIES_B (COST_ANALYSIS_CODE) and PO_COST_MST (ANALYSIS_CODE) — activity master and purchase-order cost references.

Because sixteen documented foreign keys point back to this hub, any change to a cost analysis code definition propagates across the entire process manufacturing costing model; deactivation should therefore always be preceded by dependency checks against these tables.