Search Results cm_cldr_hdr




Overview
Explore in AI Chat

Overview

CM_CLDR_HDR is the Costing Calendar Header table within the GMF (Process Manufacturing Financials) product family of Oracle E-Business Suite. It defines the header-level definition of a costing calendar, the structure that governs how process manufacturing cost rollups, period assignments, and cost method applications are sequenced over time. Each row represents one named costing calendar, identified by the CALENDAR_CODE business key, and binds that calendar to a cost method, a text template, and an operating organization context. In EBS 12.1.1 and 12.2.2 the table is part of the Process Manufacturing Cost Management schema and is used primarily by the cost rollup and period-close engines that must align cost derivation with a defined calendar horizon.

The documentation explicitly notes that this object is not implemented in the reference database, meaning the table may be deployed only where Process Manufacturing Costing is licensed and configured. Its structure, however, remains stable across the 12.1.1 and 12.2.2 releases.

The heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. In modeling terms, CM_CLDR_HDR functions as a descriptive satellite attached to core business hubs: its primary key is a single business code, and most of its non-key attributes are descriptive or referential context rather than independent entities. This classification should be treated as a design suggestion rather than a formal constraint.

Key Information Stored

The documented columns and their roles are:

  • CALENDAR_CODE — the single-column primary key (CM_CLDR_HDR_PK). This is the business key: a user-visible code naming the costing calendar. Because the surrogate and business key coincide here, the PK is a natural key rather than a generated sequence.
  • COST_MTHD_CODE — foreign key to CM_MTHD_MST, identifying the cost method applied when this calendar drives cost derivation.
  • TEXT_CODE — foreign key to CM_TEXT_HDR, referencing the text template associated with the calendar (used for descriptive or annotation content).
  • CO_CODE — foreign key to SY_ORGN_MST, associating the calendar with an operating organization or company context.

Additional descriptive columns exist beyond those documented, but the four above constitute the essential structure: one business identifier and three referential attributes that anchor the calendar to method, text, and organization dimensions. The detail-level period definitions that complete the calendar are held in CM_CLDR_DTL, not in this header table.

Common Use Cases and Queries

Typical usage centers on validating that a costing calendar is properly configured before running cost rollups or period close. A common diagnostic query resolves the cost method name and organization for a given calendar:

  • Joining CM_CLDR_HDR to CM_MTHD_MST on COST_MTHD_CODE to confirm the cost method assigned.
  • Joining to SY_ORGN_MST on CO_CODE to identify the owning organization.
  • Joining to CM_CLDR_DTL on CALENDAR_CODE to explode the period-level detail.

Sample pattern:

SELECT h.calendar_code, h.cost_mthd_code, m.cost_mthd_name, h.co_code, d.period_code
FROM cm_cldr_hdr h, cm_mthd_mst m, cm_cldr_dtl d
WHERE h.cost_mthd_code = m.cost_mthd_code
AND h.calendar_code = d.calendar_code;

Reporting use cases include auditing which organizations share a cost method, listing calendars that reference a particular text template, and identifying calendars with no detail rows (configuration gaps) prior to cost rollup execution.

Related Objects

The most significant related objects, per documented referential structure:

  • CM_CLDR_DTL — detail child table; joins on CM_CLDR_DTL.CALENDAR_CODE = CM_CLDR_HDR.CALENDAR_CODE. This is the primary dependent object.
  • CM_MTHD_MST — cost method master; joined on COST_MTHD_CODE.
  • CM_TEXT_HDR — text header master; joined on TEXT_CODE.
  • SY_ORGN_MST — organization master; joined on CO_CODE.

Together these form the complete costing calendar configuration chain: header, periods, method, annotation, and organization.