Search Results ic_cldr_hdr




Overview
Explore in AI Chat

Overview

The IC_CLDR_HDR table is a core data structure within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the header definition for an organization's fiscal inventory calendar. This table establishes the fiscal year framework, enabling the subsequent detailed setup of accounting and operational periods within the related IC_CLDR_DTL table. The inventory calendar is critical for period-end closing, inventory valuation, and financial reporting within Process Manufacturing, ensuring all transactional data is posted to the correct fiscal period. The metadata indicates this table may not be implemented in all databases, suggesting its use is specific to certain configurations or legacy data models.

Key Information Stored

The table's primary purpose is to uniquely define a fiscal year for a specific inventory organization. Its structure is anchored by a composite primary key. The key columns are ORGN_CODE, which identifies the inventory organization, and FISCAL_YEAR, which defines the calendar year. A significant foreign key relationship is maintained via the TEXT_CODE column, which links to the IC_TEXT_HDR table, allowing for descriptive text or notes associated with the calendar header. This connection to organization master data (SY_ORGN_MST) via the ORGN_CODE ensures the calendar is tied to a valid business entity.

Common Use Cases and Queries

This table is primarily referenced during period maintenance and financial reporting cycles. A common operational query involves retrieving the calendar header for a specific organization to validate or display the active fiscal year setup before opening or closing periods. For example:

  • SELECT fiscal_year, text_code FROM ic_cldr_hdr WHERE orgn_code = :org_id;

In reporting scenarios, it is frequently joined with the IC_CLDR_DTL table to generate a complete list of all periods for a fiscal year, their statuses (open, closed, future), and date ranges for transactional analysis. Data integrity checks often involve verifying that every organization defined in inventory parameters has a corresponding calendar header record for the current fiscal year.

Related Objects

The IC_CLDR_HDR table is central to a small but critical hierarchy of objects. Its most direct dependency is the IC_CLDR_DTL table, which stores the individual period details (period number, dates, status) for each header record; the relationship is enforced by a foreign key on ORGN_CODE and FISCAL_YEAR. It draws descriptive text from the IC_TEXT_HDR table via the TEXT_CODE foreign key and validates the organization code against the SY_ORGN_MST table. While not listed in the provided metadata, this calendar header likely underpins transactional tables in GMI (such as inventory transfers and cost updates) and is referenced by various inventory period close and reporting programs within the Process Manufacturing suite.