Results for “cm_mthd_mst”

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

Overview

CM_MTHD_MST is the Item Cost Methods master table within the Oracle E-Business Suite Process Manufacturing Financials (GMF) module. It stores the user-defined cost methods that govern how item costs are calculated across process manufacturing operations. Each record defines a named costing methodology along with the calculation types applied to raw materials and products, particularly for Actual Costing Methods. Because cost methods permeate virtually every costing activity — burdening, rollups, adjustments, calendars, resource charges, and general ledger item cost postings — this table functions as a foundational configuration object. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the GMF schema and is documented with 19 columns, a single-column primary key, and an extensive set of inbound foreign key references.

From a Data Vault modeling perspective, the heuristic classification of CM_MTHD_MST is hub-leaning. This reflects its role as a durable, business-key-driven master entity whose COST_MTHD_CODE is referenced by many dependent tables. A dimensional or Data Vault design would likely treat it as a hub, with descriptive attributes (descriptions, calculation types, defaults) modeled as satellites.

Key Information Stored

The table is anchored by the primary key CM_MTHD_MST_PK, defined on COST_MTHD_CODE. This code is both the surrogate identifier and the business-key candidate documented through the unique index. Key columns include:

• COST_MTHD_CODE — The unique business identifier for each cost method; primary key and the column propagated to all dependent tables.
• COST_MTHD_DESC — The user-facing description of the cost method.
• COST_TYPE — Classifies the costing approach associated with the method.
• COST_TYPE_ID — Foreign key to CST_COST_TYPES, tying the method to the Oracle Cost Management cost type.
• RMCALC_TYPE — Specifies the raw material cost calculation type.
• PRODCALC_TYPE — Specifies the product cost calculation type.
• USAGE_TYPE — Indicates how the cost method is used within costing operations.
• DEFAULT_LOT_COST_MTHD — Default lot costing method for the cost method.
• LOT_ACTUAL_COST — Flag governing actual lot costing behavior.
• DEFAULT_LOT_COST_TYPE_ID — References the default lot cost type.
• TEXT_CODE — Foreign key to CM_TEXT_HDR, linking descriptive text.
• TRANS_CNT and TRANS_START_DATE — Transition counters and effective start dates for method changeovers.
• DELETE_MARK — Standard soft-delete indicator.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include identifying the cost method applied to a given item, validating the raw material and product calculation types before running a cost rollup, and reporting on cost method configuration. A representative query retrieves defined cost methods with their calculation types:

• SELECT COST_MTHD_CODE, COST_MTHD_DESC, COST_TYPE, RMCALC_TYPE, PRODCALC_TYPE FROM GMF.CM_MTHD_MST WHERE DELETE_MARK = 0;
• Joining to incoming cost adjustment detail: SELECT a.COST_MTHD_CODE, m.COST_MTHD_DESC FROM CM_ADJS_DTL a, CM_MTHD_MST m WHERE a.COST_MTHD_CODE = m.COST_MTHD_CODE;
• Determining methods tied to general ledger item costs via GL_ITEM_CST.COST_MTHD_CODE.
• Auditing calendar and rollup control setup through CM_CLDR_HDR and CM_RLUP_CTL.

Related Objects

CM_MTHD_MST is referenced by numerous GMF costing tables. The most significant include:

• CM_ACST_LED — Actual cost ledger, joined on COST_MTHD_CODE.
• CM_ADJS_DTL — Adjustment detail, joined on COST_MTHD_CODE.
• CM_CLDR_HDR and CM_CLDR_HDR_B — Cost calendar headers, joined on COST_MTHD_CODE.
• CM_RLUP_CTL — Rollup control, joined on COST_MTHD_CODE.
• CM_RSRC_DTL — Resource detail, joined on COST_MTHD_CODE.
• CM_CMPT_DTL — Component detail, joined on COST_MTHD_CODE.
• GL_ITEM_CST — Item cost postings, joined on COST_MTHD_CODE.
• GL_PLCY_MST — Accounting policy master, joined via CREV_CURR_MTHD and CREV_PRIOR_MTHD.
• GMF_BURDEN_PERCENTAGES — Burden percentage configuration, joined on COST_MTHD_CODE.
• CM_TEXT_HDR and CST_COST_TYPES — Referenced parent tables via TEXT_CODE and COST_TYPE_ID respectively.