Search Results igc_cc_periods

Overview

GL_PERIODS is the foundational calendar period definition table in the Oracle General Ledger (GL) module, residing in the GL schema. It stores the individual accounting periods that make up every accounting calendar defined within Oracle E-Business Suite. Each row represents a single period, such as a fiscal month, quarter, or adjustment period, and is uniquely identified within a specific period set (calendar). This table is the authoritative source for period names, dates, and period-type attributes used across the entire EBS financials and sub-ledger stack.

The metadata classifies GL_PERIODS as a data-hub heuristic model, which is a fitting characterization: it acts as a central reference point from which many dependent transactional and control tables resolve their period context. Every sub-ledger, period-status, and close-management object draws on the same period definitions, making GL_PERIODS a shared dimensional reference rather than a transactional fact.

Key Information Stored

The physical schema in ETRM 12.2.2 documents 28 columns. The most significant are:

• PERIOD_SET_NAME — the accounting calendar (period set) to which the period belongs; part of the composite primary key and a foreign key to GL_PERIOD_SETS.
• PERIOD_NAME — the human-readable period identifier (e.g., "JAN-24"); the other half of the composite primary key and the value most frequently referenced throughout EBS.
• START_DATE, END_DATE — the system dates defining the beginning and end of the period.
• PERIOD_TYPE — the classification of the period (e.g., Month, Quarter, Year), foreign-keyed to GL_PERIOD_TYPES.
• PERIOD_YEAR and PERIOD_NUM — the fiscal year and sequential period number, essential for ordering and reporting.
• QUARTER_NUM and QUARTER_START_DATE — quarter-level attributes supporting quarterly reporting.
• YEAR_START_DATE — the start date of the fiscal year containing the period.
• ADJUSTMENT_PERIOD_FLAG — indicates whether the period is an adjustment (closing) period.
• ENTERED_PERIOD_NAME — the period in which entries are recorded in place of the natural period.
• DESCRIPTION and the ATTRIBUTE1–ATTRIBUTE8/ CONTEXT DFF columns — descriptive and extensible flexfield data.

The surrogate/business primary key is GL_PERIODS_PK on (PERIOD_SET_NAME, PERIOD_NAME). Two unique indexes are documented as business-key candidates: GL_PERIODS_U1 (PERIOD_NAME, PERIOD_SET_NAME, ZD_EDITION_NAME) and GL_PERIODS_U2 (PERIOD_SET_NAME, PERIOD_TYPE, PERIOD_YEAR, PERIOD_NUM, ZD_EDITION_NAME), the latter enforcing that each period number is unique within its type, year, and calendar.

Common Use Cases and Queries

GL_PERIODS is central to period-based reporting, period-close validation, and joining transactional data to calendar dates. A common pattern joins sub-ledger data to GL_PERIODS to translate stored period names into date ranges:

• Resolving a period name to its start and end dates for reporting windows: SELECT START_DATE, END_DATE FROM GL_PERIODS WHERE PERIOD_SET_NAME = :set AND PERIOD_NAME = :name;
• Listing all periods in a calendar for the current year ordered by fiscal sequence: SELECT PERIOD_NAME, START_DATE, END_DATE FROM GL_PERIODS WHERE PERIOD_SET_NAME = :set AND PERIOD_YEAR = :yr ORDER BY PERIOD_NUM;
• Identifying open or adjustment periods during close: filter on ADJUSTMENT_PERIOD_FLAG and join to period-status tables.
• Mapping transaction periods to fiscal quarters for management reporting using QUARTER_NUM.

Related Objects

GL_PERIODS references GL_PERIOD_SETS (via PERIOD_SET_NAME) and GL_PERIOD_TYPES (via PERIOD_TYPE). It is in turn referenced by numerous dependent objects, the most significant being:

• CN_PERIOD_STATUSES_ALL — period open/closed status by period set and period name.
• ORG_ACCT_PERIODS — inventory organization accounting periods.
• CST_PAC_PERIODS — costing period-close control records.
• IGC_CC_PERIODS and IGC_CBC_JE_LINES — grants/consolidation period context and journal lines.
• AS_MC_SALES_CREDITS_DEN — sales-credit conversion period references.
• AMW_CERTIFICATION_B — certification period references.

Each of these joins to GL_PERIODS on the (PERIOD_SET_NAME, PERIOD_NAME) composite key, confirming its role as the shared hub for period definitions across the EBS application suite.