Search Results ic_cldr_hdr_b_pk

Overview

The IC_CLDR_HDR_B table is a core master data table within the Process Manufacturing Inventory (GMI) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the header definition for an organization's fiscal calendar, establishing the foundational structure for financial and operational period management. Each record defines a fiscal year for a specific inventory organization, enabling the system to organize transactional data, such as inventory movements and cost accounting, into discrete time periods. This table is essential for period-end closing processes, financial reporting, and ensuring that all inventory transactions are posted to the correct accounting period. The detailed period definitions, such as start and end dates and period statuses, are stored in the related child table, IC_CLDR_DTL.

Key Information Stored

The table's primary purpose is to uniquely identify a fiscal year for an organization. Its structure, as indicated by its primary and foreign keys, centers on two critical columns. The ORGN_CODE column stores the identifier for the inventory organization, linking the calendar to a specific entity defined in SY_ORGN_MST_B. The FISCAL_YEAR column stores the numeric year value (e.g., 2024) for that organization's fiscal calendar. Together, these columns form the table's primary key (IC_CLDR_HDR_B_PK). Additional descriptive attributes are likely present, such as a TEXT_CODE column, which acts as a foreign key to IC_TEXT_HDR, allowing for descriptive text or comments to be associated with the fiscal year definition.

Common Use Cases and Queries

This table is primarily accessed for setup, validation, and reporting related to the fiscal calendar. A common operational query involves listing all defined fiscal years for an organization to verify setup or select a specific year for period maintenance. For example: SELECT fiscal_year, text_code FROM gmi.ic_cldr_hdr_b WHERE orgn_code = :org_id ORDER BY fiscal_year;. In reporting scenarios, it is frequently joined to the IC_CLDR_DTL table to generate period calendars or validate that a given transaction date falls within an open period. Database administrators and functional consultants may query this table to troubleshoot period closure issues or to ensure referential integrity before migrating calendar data between environments.

Related Objects

• IC_CLDR_DTL: The primary child table. It holds the detailed period definitions (period number, dates, status) for each fiscal year and organization defined in IC_CLDR_HDR_B.
• SY_ORGN_MST_B: The master table for inventory organizations. The ORGN_CODE in IC_CLDR_HDR_B references this table to validate the organization.
• IC_TEXT_HDR: Provides descriptive flexfield or textual comments for the calendar header via the TEXT_CODE foreign key relationship.
• Various transactional tables in the GMI schema likely contain foreign keys to the period details (IC_CLDR_DTL), which inherently depend on the header definition in IC_CLDR_HDR_B for context.