Search Results cm_cldr_dtl




Overview
Explore in AI Chat

Overview

The CM_CLDR_DTL table is a core data structure within the Oracle E-Business Suite Process Manufacturing Financials (GMF) module. It functions as the detailed repository for costing calendar periods, which are fundamental to the periodic costing and financial accounting processes in a manufacturing environment. This table stores the individual period definitions that roll up into a costing calendar defined in its parent header table. Its primary role is to establish the temporal framework for capturing, calculating, and reporting inventory, resource, and overhead costs on a periodic basis, ensuring costs are aligned with specific accounting periods for accurate financial reporting and analysis.

Key Information Stored

The table's structure is defined by a composite primary key consisting of CALENDAR_CODE and PERIOD_CODE, uniquely identifying each period within a specific calendar. While the provided metadata does not list all columns, the foreign key relationships imply the table likely contains descriptive attributes for each period, such as period name, start date, end date, status (open, closed, future), and a link to a text code (CM_TEXT_HDR) for descriptive flexfield or notes. The CALENDAR_CODE column is critical, as it links each detail record to its parent calendar in both the CM_CLDR_HDR and CM_CLDR_HDR_B tables, establishing the calendar hierarchy.

Common Use Cases and Queries

This table is central to any operation involving period-based cost transactions. Common use cases include validating if a period is open for cost updates, running period-end cost aggregation and reconciliation reports, and ensuring data integrity during cost roll-up and burden calculation processes. A typical query would retrieve all open periods for a given calendar to process transactions or generate period-specific cost reports. For example:

  • Retrieving period details: SELECT calendar_code, period_code, period_name, start_date, end_date, status FROM gmf.cm_cldr_dtl WHERE calendar_code = '&CALENDAR' ORDER BY start_date;
  • Validating a period for transaction entry: SELECT 'Period is Closed' FROM gmf.cm_cldr_dtl WHERE calendar_code = :p_cal_code AND period_code = :p_period_code AND status != 'O';

Reporting often involves joining this table with various cost sub-ledger tables to analyze costs by accounting period.

Related Objects

As indicated by its extensive foreign key relationships, CM_CLDR_DTL is a pivotal reference table for numerous GMF and General Ledger (GL) sub-ledgers. Key dependent objects include:

These relationships enforce referential integrity, ensuring all cost transactions are posted to valid, defined calendar periods.