Search Results gl_periods_v




Overview
Explore in AI Chat

Overview

GL_PERIODS_V is an APPS-owned database view in the Oracle E-Business Suite General Ledger (GL) module. Within the ETRM 12.1.1 / 12.2.2 metadata, the object is documented with the description "10SC ONLY," indicating that it was originally created for a specific release or localization scope rather than as a general-purpose interface. The view is catalogued with a status of VALID and resides in the APPS schema alongside the standard GL period definition tables.

Functionally, GL_PERIODS_V presents a flattened, reporting-friendly projection of accounting period definitions. It joins the base period entity (GL_PERIODS) to the period type entity (GL_PERIOD_TYPES) so that consumers obtain not only the concrete calendar period (name, start date, end date, period number) but also descriptive attributes of the accounting calendar structure (the user-facing period type name and the number of periods per fiscal year). This makes the view convenient for date-driven reporting, period-close dashboards, and integration queries that must resolve a period name to its boundaries without performing the join manually. Because the view name carries a "_V" suffix, it is intended for read-only consumption rather than for DML.

Underlying Base Objects

The documented view text is defined over two synonyms:

  • GL_PERIODS (SYNONYM) — aliased as PER; supplies period names, dates, period type, period year, period number, quarter number, entered period name, adjustment period flag, description, WHO audit columns, and the DFF columns CONTEXT and ATTRIBUTE1–ATTRIBUTE15.
  • GL_PERIOD_TYPES (SYNONYM) — aliased as PT; supplies USER_PERIOD_TYPE and NUMBER_PER_FISCAL_YEAR.

The two are related through the equality PER.PERIOD_TYPE = PT.PERIOD_TYPE. The view exposes PER.ROWID as ROW_ID, giving each row a stable physical identifier for the underlying GL_PERIODS record.

Key Columns

  • PERIOD_NAME — the accounting period identifier (for example, JAN-25).
  • PERIOD_SET_NAME — the accounting calendar (period set) to which the period belongs.
  • START_DATE / END_DATE — the inclusive boundaries of the period.
  • PERIOD_TYPE — the internal period type code used to join to GL_PERIOD_TYPES.
  • USER_PERIOD_TYPE — the user-facing name of the period type.
  • PERIOD_YEAR / PERIOD_NUM / QUARTER_NUM — the fiscal year, period sequence, and quarter sequence.
  • ENTERED_PERIOD_NAME — the period name entered by the user, which may differ from PERIOD_NAME in certain calendar configurations; this column is the object of the searched term.
  • ADJUSTMENT_PERIOD_FLAG — indicates whether the row represents an adjustment period.
  • NUMBER_PER_FISCAL_YEAR — the number of periods defined in the fiscal year for the period type.

Common Use Cases and Queries

Typical usage includes resolving a period name to its date range, listing all periods for a calendar and year, and identifying adjustment periods. A representative query is:

  • SELECT period_name, start_date, end_date FROM gl_periods_v WHERE period_set_name = :p_set AND period_name = :p_period;
  • SELECT period_name, entered_period_name, period_num FROM gl_periods_v WHERE period_set_name = :p_set AND period_year = :p_year ORDER BY period_num;
  • SELECT period_name FROM gl_periods_v WHERE adjustment_period_flag = 'Y';

Because the view is documented as "10SC ONLY," implementations should confirm its availability in the target environment before relying on it, and prefer it for read-only reporting rather than transactional processing.