Search Results cm_cldr_hdr




Overview
Explore in AI Chat

Overview

The CM_CLDR_HDR table is the central repository for defining costing calendars within Oracle E-Business Suite Process Manufacturing Financials (GMF). It serves as the header record for a costing calendar, which is a critical master data structure used to define the accounting periods for cost calculations, inventory valuation, and financial reporting in a manufacturing environment. Each unique calendar code in this table represents a distinct fiscal or costing period structure that can be associated with a specific costing method and legal entity (company). Its primary role is to establish the temporal framework upon which detailed period definitions (stored in CM_CLDR_DTL) and associated cost transactions are built.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships. The primary identifier is the CALENDAR_CODE, a unique key for each costing calendar. The table links to other core master data through foreign keys. The COST_MTHD_CODE associates the calendar with a specific costing method defined in the CM_MTHD_MST table. The CO_CODE links the calendar to a legal company or organization defined in SY_ORGN_MST. Additionally, the TEXT_CODE provides a link to descriptive flexfield or textual information stored in the CM_TEXT_HDR table, allowing for extended descriptive attributes. While specific descriptive columns like calendar name are not detailed in the provided metadata, they are typically present in such header tables.

Common Use Cases and Queries

The primary use case is the setup and maintenance of the costing calendar hierarchy, which is foundational for period-end closing processes in Process Manufacturing. Common operational queries involve retrieving calendars for a specific company or costing method for validation and reporting. A typical SQL pattern to list all calendars with their associated company and costing method would be:

  • SELECT hdr.calendar_code, org.co_code, mthd.cost_mthd_code
  • FROM cm_cldr_hdr hdr, sy_orgn_mst org, cm_mthd_mst mthd
  • WHERE hdr.co_code = org.co_code
  • AND hdr.cost_mthd_code = mthd.cost_mthd_code;

This table is also frequently joined to its detail table, CM_CLDR_DTL, to report on the full period structure of a calendar for financial analysis and period status reviews.

Related Objects

CM_CLDR_HDR is a central node in the GMF costing schema. Its most direct relationship is with the CM_CLDR_DTL table, which stores the individual period definitions (start date, end date, status) for each calendar code. It has mandatory dependencies on several master data tables: CM_MTHD_MST (Costing Method), SY_ORGN_MST (Company), and CM_TEXT_HDR (Descriptive Text). As a foundational setup table, it is referenced by various transactional and reporting entities within the GMF module that require a valid costing period context, such as cost accumulation and inventory valuation programs. The metadata indicates a foreign key relationship from CM_CLDR_HDR to CM_MTHD_MST, establishing the costing method as a parent entity.