Search Results quarter_num




Overview
Explore in AI Chat

Overview

The view PA_REP_QUARTER_PA_V is an Oracle Projects (PA) reporting view owned by the APPS schema and created in every Oracle E-Business Suite environment, including releases 12.1.1 and 12.2.2. Its purpose, as documented, is to retrieve Projects quarter numbers. It is a small, read-only lookup view intended to expose the distinct set of fiscal/period quarter numbers that apply to the Projects implementation period set and period type defined in PA_IMPLEMENTATIONS.

The view returns only two columns, QUARTER_NUM and ORG_ID, making it a compact reference source for query builders, concurrent programs, BI Publisher data templates, and custom reports that need to translate a quarter classification into a selectable or queryable value. Because it derives from the implementation record rather than from transactional data, its row set is stable for a given configuration and changes only when the period set or period type assigned to the Projects implementation is altered.

Underlying Base Objects

The documented view definition is a join across two objects:

  • PA_IMPLEMENTATIONS — the Oracle Projects implementation table, referenced by the synonym. It supplies ORG_ID, along with the configuration columns PERIOD_SET_NAME and PA_PERIOD_TYPE.
  • GL_PERIODS — the General Ledger accounting period definition table, referenced by the synonym. It supplies the QUARTER_NUM value and the PERIOD_SET_NAME and PERIOD_TYPE columns used for correlation.

The join condition restricts the General Ledger calendars to the period set name and period type assigned to the Projects implementation, and the result set is reduced with DISTINCT and ordered by QUARTER_NUM. This design means that the view does not enumerate every GL calendar; it enumerates only the calendars relevant to Oracle Projects in the current instance.

Key Columns

Two columns are exposed by the view:

  • QUARTER_NUM — the quarter number drawn from GL_PERIODS.QUARTER_NUM. This is the numeric quarter within the accounting year (typically 1 through 4) for the eligible Projects calendars. It is the primary value users search for when locating this view.
  • ORG_ID — the operating unit identifier from PA_IMPLEMENTATIONS.ORG_ID, identifying the business unit to which the implementation record, and therefore the returned quarter set, belongs.

Common Use Cases and Queries

The view is most commonly used to populate quarter selections, validate quarter values against the Projects configuration, and drive comparative reporting by fiscal quarter. A typical query to return the available quarters is:

  • SELECT quarter_num, org_id FROM pa_rep_quarter_pa_v ORDER BY quarter_num;
  • SELECT quarter_num FROM pa_rep_quarter_pa_v WHERE org_id = :p_org_id ORDER BY quarter_num;
  • SELECT DISTINCT quarter_num FROM pa_rep_quarter_pa_v WHERE quarter_num = :p_quarter;

Because the view is defined over configuration tables, it executes efficiently and can be joined to GL period data, PA reporting views, or custom fact tables using QUARTER_NUM as the link. When filtered by ORG_ID, it ensures that only the quarter numbers valid for the specified operating unit are returned, which is the recommended pattern in multi-organization deployments.