Search Results current_year_ind




Overview
Explore in AI Chat

Overview

IC_CLDR_HDR_B is the inventory calendar header table within the GMI (Process Manufacturing Inventory) module of Oracle E-Business Suite, and it is present in both the 12.1.1 and 12.2.2 releases. It is owned by the GMI schema and holds status VALID. The table defines the fiscal year header level of the inventory calendar: each row establishes a fiscal year for a given organization, while the individual calendar periods that make up that fiscal year are stored at a lower level in IC_CLDR_DTL. This two-tier design allows an organization to define year-level attributes (open or closed status, current-year flag, description, in-use flag) once, and then attach any number of period records beneath it.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. The table behaves less like an independent hub of business entities and more like a descriptive satellite: its key is composite and tightly bound to an operating unit, and it carries descriptive and status attributes (CALENDAR_DESC, BEGIN_DATE, CLOSED_YEAR_IND, CURRENT_YEAR_IND, IN_USE, DELETE_MARK) rather than acting as a standalone hub of unique calendar identities. Modelers treating GMI data in a Data Vault should consider this as a suggestion rather than a mandate, since the composite primary key includes an organization foreign key that already belongs to another hub.

Key Information Stored

The documented physical schema contains 14 columns. The most important are outlined below.

  • ORGN_CODE – The operating unit or organization code. This is both part of the composite primary key and a foreign key to SY_ORGN_MST_B, anchoring each calendar year to a specific organization.
  • FISCAL_YEAR – The fiscal year identifier. Together with ORGN_CODE it forms the business key and primary key IC_CLDR_HDR_B_PK.
  • CALENDAR_DESC – A descriptive name or text associated with the calendar header, useful for reporting.
  • BEGIN_DATE – The start date of the fiscal year, typically used to seed or validate period definitions in IC_CLDR_DTL.
  • CLOSED_YEAR_IND – Indicator flagging whether the fiscal year has been closed to transactions.
  • CURRENT_YEAR_IND – Indicator marking the fiscal year currently active for the organization.
  • IN_USE – Flag denoting whether the calendar header record is actively used.
  • DELETE_MARK – Soft-delete marker used to logically retire records without physical removal, a common GMI pattern.
  • TEXT_CODE – Foreign key to IC_TEXT_HDR, linking a block of descriptive text to the calendar header.
  • Audit columns – CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN provide standard Oracle Applications WHO-column auditing.

The surrogate/primary key is IC_CLDR_HDR_B_PK, defined on (ORGN_CODE, FISCAL_YEAR). Because this key is natural and business-meaningful rather than a synthetic sequence value, the unique index on these two columns is simultaneously the primary key and the strongest business-key candidate.

Common Use Cases and Queries

Typical use cases include identifying the currently open fiscal year for an organization, validating period structures before transactions post, and reporting calendar coverage across organizations.

  • Retrieve the active or current fiscal year for an organization:

SELECT orgn_code, fiscal_year, calendar_desc, begin_date FROM gmi.ic_cldr_hdr_b WHERE orgn_code = :orgn AND current_year_ind = 'Y' AND delete_mark = 0;

  • List open years not yet closed:

SELECT orgn_code, fiscal_year, begin_date FROM gmi.ic_cldr_hdr_b WHERE closed_year_ind = 'N' AND nvl(delete_mark,0) = 0 ORDER BY orgn_code, fiscal_year;

  • Join to detail periods to report full calendar structure:

SELECT h.orgn_code, h.fiscal_year, d.period_code, d.begin_date, d.end_date FROM gmi.ic_cldr_hdr_b h, gmi.ic_cldr_dtl d WHERE h.orgn_code = d.orgn_code AND h.fiscal_year = d.fiscal_year;

Reporting queries should always filter on DELETE_MARK to exclude logically deleted rows and reference the primary key columns to ensure efficient index access.

Related Objects

  • IC_CLDR_DTL – The detail (period) table. It references IC_CLDR_HDR_B on (ORGN_CODE, FISCAL_YEAR) and holds individual calendar periods.
  • SY_ORGN_MST_B – The organization master. IC_CLDR_HDR_B.ORGN_CODE references this table, providing the operating unit context.
  • IC_TEXT_HDR – The text header table. IC_CLDR_HDR_B.TEXT_CODE references it, supplying long descriptive text for the calendar header.
  • IC_CLDR_HDR_B_PK – The unique index enforcing the primary key on (ORGN_CODE, FISCAL_YEAR).

Process Manufacturing inventory, cost, and calendar maintenance concurrent programs read and validate against these objects when determining valid fiscal periods for transactions.