Search Results current_period_ind




Overview
Explore in AI Chat

Overview

IC_CLDR_DTL is the inventory calendar detail table in the Oracle E-Business Suite Process Manufacturing Inventory module (GMI). It stores the individual fiscal period records that make up an organization's inventory calendar, forming the transactional grain that rolls up to the calendar header held in IC_CLDR_HDR and IC_CLDR_HDR_B. Each row represents one accounting period for a specific organization and fiscal year, carrying the dates, status flags, and descriptive attributes that govern period-end processing, inventory valuation cut-offs, and period-close activity across process manufacturing.

In Data Vault modeling terms, the mined foreign key structure classifies this table as satellite-leaning. This is a heuristic modeling suggestion: IC_CLDR_DTL behaves like a descriptive satellite attached to the calendar header hub (IC_CLDR_HDR / IC_CLDR_HDR_B, keyed by ORGN_CODE and FISCAL_YEAR), holding the period-level descriptive and status attributes rather than acting as an independent hub or as a pure link between two hubs. Its child relationship to IC_WHSE_STS reinforces this role, since downstream status records depend on the period descriptor.

Key Information Stored

The table contains fifteen documented columns in the GMI schema. The most significant are:

  • PERIOD_ID — Surrogate primary key, enforced by IC_CLDR_DTL_PK. Uniquely identifies each calendar period row and is the column referenced by dependent tables.
  • ORGN_CODE, FISCAL_YEAR, PERIOD — The business-key triplet enforced by unique index IC_CLDR_DTL_U1. Together they identify a period within an organization's fiscal calendar and are the natural keys used in joins to the header tables.
  • PERIOD_END_DATE — The closing date of the accounting period, used to constrain transactions and drive period-close logic.
  • PERIOD_DESC — The human-readable description of the period for reporting and user display.
  • CLOSED_PERIOD_IND — Flag indicating whether the period has been closed to further inventory activity.
  • CURRENT_PERIOD_IND — Flag identifying the organization's currently open period.
  • PERIOD_TYPE — Classifies the period (for example, standard accounting periods versus adjustment periods).
  • TEXT_CODE — Foreign key to IC_TEXT_HDR, providing extended descriptive text for the period.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle audit columns tracking who created and last modified each row.

Common Use Cases and Queries

Typical reporting and integration scenarios include determining the current open period for an organization, validating whether a date falls within a closed period before posting inventory transactions, and joining period detail to warehouse status records for period-close reconciliation.

A common pattern retrieves the current period for an organization:

  • SELECT period_id, orgn_code, fiscal_year, period, period_end_date FROM gmi.ic_cldr_dtl WHERE orgn_code = :orgn AND current_period_ind = 'Y';

Period-close validation checks whether a target date is closed:

  • SELECT closed_period_ind FROM gmi.ic_cldr_dtl WHERE orgn_code = :orgn AND :txn_date BETWEEN (period_end_date - 30) AND period_end_date;

Warehouse status reporting joins the period descriptor to IC_WHSE_STS:

  • SELECT d.period, d.period_desc, s.* FROM gmi.ic_cldr_dtl d, gmi.ic_whse_sts s WHERE s.period_id = d.period_id AND d.orgn_code = :orgn;

Related Objects

  • IC_CLDR_HDR and IC_CLDR_HDR_B — Calendar header tables. IC_CLDR_DTL.ORGN_CODE joins to the header organization, forming the header-to-detail calendar relationship. Note that both variants are referenced for the ORGN_CODE/FISCAL_YEAR foreign key.
  • IC_TEXT_HDR — Referenced via IC_CLDR_DTL.TEXT_CODE, supplying extended descriptive text for periods.
  • IC_WHSE_STS — The primary dependent table. IC_WHSE_STS.PERIOD_ID references IC_CLDR_DTL.PERIOD_ID, meaning warehouse status records are keyed by period.
  • IC_CLDR_DTL_PK and IC_CLDR_DTL_U1 — The primary key and unique index constraints that enforce row identity and business-key uniqueness respectively.

Together these objects define the calendar backbone against which process manufacturing organizations close and open inventory periods.