Search Results quarter_start_date




Overview
Explore in AI Chat

Overview

GL_PERIOD_STATUSES_NAME_V is a General Ledger view owned by the APPS schema in Oracle E-Business Suite. Per the ETRM documentation, its description is stated as "10SC ONLY," indicating that the object is intended for a restricted deployment context rather than for general-purpose use across all EBS implementations. The view exposes the calendar and status attributes of accounting periods as recorded in the General Ledger period status store, presenting period identification, period boundaries, quarter and year anchors, and the closing status of each period.

Functionally, the view supplies the same column set as its underlying base object but is packaged under a dedicated name, which allows reporting and integration components to reference a stable, named interface rather than the base table directly. It carries no filter predicate or join in its defining text, so it behaves as a straightforward projection of GL_PERIOD_STATUSES and inherits that table's row granularity — one row per application, ledger, and period combination. Because period status is the authoritative indicator of whether a period is open, closed, or permanently closed, the view is relevant to any process that must determine whether accounting activity may be posted or reversed for a given ledger and period. The presence of QUARTER_START_DATE and QUARTER_NUM makes it directly responsive to searches such as "quarter_start_date," which target the beginning boundary of the fiscal quarter containing a period.

Underlying Base Objects

The documented base object is GL_PERIOD_STATUSES, referenced through a synonym. The view text selects from that object using the alias GPS and maps each source column to an identically named output column:

No aggregation, restriction, or transformation is applied, so row counts and values match GL_PERIOD_STATUSES exactly for the columns exposed.

Key Columns

  • APPLICATION_ID / LEDGER_ID — identify the owning application and ledger; both are required to disambiguate periods in multi-ledger environments.
  • PERIOD_NAME — the user-facing period label, such as JAN-25.
  • PERIOD_YEAR, PERIOD_NUM — the fiscal year and the sequential period number within it.
  • QUARTER_NUM — the quarter to which the period belongs.
  • START_DATE / END_DATE — the accounting period's start and end dates.
  • QUARTER_START_DATE — the first day of the quarter containing the period; central to quarter-based reporting and to the queried term.
  • YEAR_START_DATE — the first day of the fiscal year containing the period.
  • ADJUSTMENT_PERIOD_FLAG — indicates whether the row represents an adjustment period.
  • CLOSING_STATUS — the period's status, typically Open, Closed, or Permanently Closed.
  • EFFECTIVE_PERIOD_NUM — the effective order of the period, useful for range comparisons.

Common Use Cases and Queries

Typical scenarios include determining whether a period permits posting, aligning transactions to the correct quarter, and populating period selection lists in reporting tools. A representative query resolves the current period and its quarter anchor for a ledger:

SELECT PERIOD_NAME, START_DATE, END_DATE, QUARTER_START_DATE, CLOSING_STATUS FROM APPS.GL_PERIOD_STATUSES_NAME_V WHERE LEDGER_ID = :ledger_id AND TRUNC(SYSDATE) BETWEEN START_DATE AND END_DATE;

A second pattern lists closed periods within a quarter for reconciliation:

SELECT PERIOD_NAME, QUARTER_NUM, QUARTER_START_DATE, CLOSING_STATUS FROM APPS.GL_PERIOD_STATUSES_NAME_V WHERE LEDGER_ID = :ledger_id AND QUARTER_NUM = :quarter AND CLOSING_STATUS = 'C';

Because the view is documented as "10SC ONLY," implementers should confirm availability and intended usage before adopting it in custom code on 12.1.1 or 12.2.2.