Search Results ic_cldr_dtl




Overview
Explore in AI Chat

Overview

The IC_CLDR_DTL table is a core data object within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the inventory calendar detail table, storing the definition of individual accounting periods within a fiscal year for a specific organization. This table is critical for establishing the financial and operational time framework used for inventory transactions, period-end closings, and reporting. It enables the system to enforce period status controls, ensuring that inventory movements and valuations are recorded against the correct and open accounting period.

Key Information Stored

The table's primary key (IC_CLDR_DTL_PK) is the PERIOD_ID, a unique system-generated identifier for each calendar period record. Other essential columns include ORGN_CODE, which identifies the inventory organization, and FISCAL_YEAR and PERIOD, which together define the specific accounting period (e.g., period 3 of fiscal year 2025). These three columns also form a unique key (IC_CLDR_DTL_U1). The table maintains a foreign key relationship to the IC_CLDR_HDR table (via ORGN_CODE and FISCAL_YEAR) to link the period detail to its parent calendar header. The TEXT_CODE column provides a link to descriptive text stored in the IC_TEXT_HDR table.

Common Use Cases and Queries

The primary use case is to validate and control inventory transactions against open periods. Before posting any material transaction, the system will reference this table to confirm the target period is active. Common queries involve listing all periods for an organization, checking the status of a specific period, or identifying open periods for transaction entry. For example, to find all periods for a fiscal year, one might use:

  • SELECT period_id, period, period_desc FROM gmi.ic_cldr_dtl WHERE orgn_code = '<ORG>' AND fiscal_year = <YEAR> ORDER BY period;

Reporting use cases include generating period-based inventory valuation reports, transaction history summaries, and supporting the financial reconciliation process during period close.

Related Objects

IC_CLDR_DTL has defined relationships with several key inventory tables. It is a child table to IC_CLDR_HDR (and IC_CLDR_HDR_B), which defines the fiscal calendar header. It is referenced by the IC_WHSE_STS table via the PERIOD_ID column, linking period definitions to warehouse status. The TEXT_CODE column links to the IC_TEXT_HDR table for descriptive text. These relationships ensure data integrity and provide the structural foundation for period-sensitive inventory processing within Oracle Process Manufacturing.