Results for “cm_cldr_hdr_b”

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

Overview

CM_CLDR_HDR_B is the Costing Calendar Header table in the Oracle E-Business Suite Process Manufacturing Financials (GMF) product. It resides in the GMF schema and holds the controlling definition of a costing calendar used by Process Manufacturing costing and cost rollup processes. Each row in this table establishes a named calendar that governs how process costs are accumulated, periodized, and closed for a given operating organization. Because it is the parent of the calendar detail table CM_CLDR_DTL, the header defines the identity, scope, and costing methodology binding for every period-level record belonging to the calendar.

Based on the foreign key topology mined from the ETRM metadata, the object is classified heuristically as satellite-leaning in a Data Vault model. The table carries descriptive and control attributes keyed by a single business identifier, with few dependent references outward, which is characteristic of a satellite attached to a calendar hub rather than a true relationship link.

Key Information Stored

The table comprises 44 documented columns, of which the following are the most significant for functional and reporting purposes:

• CALENDAR_CODE — the defined primary key (CM_CLDR_HDR_B_PK) and the sole unique business-key candidate. It uniquely identifies each costing calendar and is the column propagated to child detail records.
• CALENDAR_DESC — the descriptive name of the calendar presented in user-facing forms and reports.
• CO_CODE — the operating organization (company) to which the calendar is bound; it carries a foreign key to SY_ORGN_MST_B.
• COST_MTHD_CODE — the costing method assigned to the calendar, with a foreign key to CM_MTHD_MST. This determines how cost is computed for items costed under the calendar.
• START_DATE — the effective start of the calendar's validity window.
• FISCAL_IND — an indicator distinguishing fiscal calendar behavior from standard calendar behavior.
• IN_USE and DELETE_MARK — status flags controlling whether the calendar is active and whether it has been logically deleted.
• TEXT_CODE — a reference into CM_TEXT_HDR, providing extended text associated with the calendar header.
• Standard WHO audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN support auditability and change tracking.
• ATTRIBUTE1 through ATTRIBUTE30 — the Oracle DFF descriptive flexfield segments, reserved for customer-specific extension of the calendar header.

Common Use Cases and Queries

Cost accountants and implementation consultants use CM_CLDR_HDR_B to trace which costing calendar and costing method apply to a given operating organization, and to validate that period activity in CM_CLDR_DTL belongs to an active calendar. A typical query joins the header to its detail records to enumerate the periods of a calendar:

• SELECT h.CALENDAR_CODE, h.CALENDAR_DESC, d.* FROM GMF.CM_CLDR_HDR_B h JOIN GMF.CM_CLDR_DTL d ON d.CALENDAR_CODE = h.CALENDAR_CODE WHERE h.CO_CODE = :co_code AND h.IN_USE = 1;
• Resolving the costing method for a calendar: SELECT c.CALENDAR_CODE, c.COST_MTHD_CODE, m.* FROM GMF.CM_CLDR_HDR_B c JOIN GMF.CM_MTHD_MST m ON m.COST_MTHD_CODE = c.COST_MTHD_CODE;
• Listing calendars by organization: SELECT CALENDAR_CODE, CALENDAR_DESC, START_DATE, FISCAL_IND FROM GMF.CM_CLDR_HDR_B WHERE CO_CODE = :org ORDER BY START_DATE;
• Locating flexfield-driven customizations: SELECT CALENDAR_CODE, ATTRIBUTE1, ATTRIBUTE2 FROM GMF.CM_CLDR_HDR_B WHERE ATTRIBUTE_CATEGORY IS NOT NULL.

Related Objects

The following objects are most significant in relation to CM_CLDR_HDR_B, joined on the columns identified in the documented foreign key structure:

• CM_CLDR_DTL — the calendar detail (period) table; joined via CM_CLDR_DTL.CALENDAR_CODE = CM_CLDR_HDR_B.CALENDAR_CODE. This is the primary child and the main consumer of the header.
• CM_MTHD_MST — costing method master; joined via CM_CLDR_HDR_B.COST_MTHD_CODE.
• SY_ORGN_MST_B — operating organization master; joined via CM_CLDR_HDR_B.CO_CODE.
• CM_TEXT_HDR — text header repository; joined via CM_CLDR_HDR_B.TEXT_CODE for extended descriptive text.
• CM_CLDR_HDR_TL — the translated/attribute-level companion table commonly deployed alongside GMF base tables where multilingual or additional descriptive columns are required.
• Cost rollup and period close concurrent programs in Process Manufacturing Financials that read the calendar hierarchy in order to determine valid costing periods and their sequence.