Search Results cm_cldr_hdr_b




Overview
Explore in AI Chat

Overview

The CM_CLDR_HDR_B table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the header table for costing calendars, which are fundamental structures for defining accounting periods used in cost calculations and financial reporting for process manufacturing operations. This table stores the master definition of a calendar, including its name, associated costing method, and organizational context. Its integrity is critical for ensuring period-based cost rollups, variance analysis, and inventory valuation are performed against a consistent and valid time framework.

Key Information Stored

As the header record, CM_CLDR_HDR_B contains the defining attributes for a costing calendar. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships indicate its critical columns. The CALENDAR_CODE is the unique identifier and primary key for the calendar definition. The COST_MTHD_CODE links the calendar to a specific costing method defined in CM_MTHD_MST. The CO_CODE associates the calendar with a specific company or organization via SY_ORGN_MST_B. The TEXT_CODE provides a link to descriptive flexfield or textual information stored in CM_TEXT_HDR. Other typical columns in such a header table would include fields like DESCRIPTION, START_DATE, END_DATE, and STATUS to control the calendar's active lifecycle.

Common Use Cases and Queries

This table is primarily accessed for setup validation, period closure tasks, and cost reporting. A common operational query involves listing all active calendars for a specific company and costing method to verify setup before a period close. For example: SELECT calendar_code, description FROM gmf.cm_cldr_hdr_b WHERE co_code = :p_co_code AND cost_mthd_code = :p_mthd_code AND SYSDATE BETWEEN start_date AND end_date;. During month-end costing processes, applications join this table to its detail table, CM_CLDR_DTL, to validate that all required periods (e.g., weeks, months) are defined and open for transaction posting and cost calculation. Reporting use cases include analyzing cost accumulation across different calendar periods or auditing calendar definitions against organizational hierarchies.

Related Objects

CM_CLDR_HDR_B is centrally connected to several key GMF tables through documented foreign key relationships. Its primary child table is CM_CLDR_DTL, which stores the individual period definitions (e.g., start date, end date, status) for each calendar, joined on CALENDAR_CODE. It references master data in three key tables: CM_MTHD_MST (via COST_MTHD_CODE) to define the applicable costing method, SY_ORGN_MST_B (via CO_CODE) to tie the calendar to an organization, and CM_TEXT_HDR (via TEXT_CODE) for extended descriptive text. These relationships ensure referential integrity across the costing calendar's definition, its organizational scope, and its associated costing methodology.