Search Results pa_rep_period_dates_v




Overview
Explore in AI Chat

Overview

The PA_REP_PERIOD_DATES_V view is an Oracle Projects (PA) reporting and integration object that exposes period definitions along with their start and end dates. Its stated purpose is to display information about period types, including the period name and the corresponding start and end dates. Because Oracle Projects reporting and forecasting frequently must reconcile Projects periods against the General Ledger calendar, this view provides a unified, book-aware picture of period boundaries.

The view is a UNION-based construct. It returns rows sourced from three separate period derivations, each distinguished by a literal type indicator in the first column: 'GL' for General Ledger accounting periods, 'PA' for Oracle Projects periods, and 'QR' for GL quarter-level aggregations. This design allows downstream reports and integrations to consume GL, PA, and quarter period dates through a single interface rather than querying each calendar independently.

The user search term gl_date_period_map is directly relevant: the GL branch of the view joins GL_DATE_PERIOD_MAP to map period types and names to the active GL calendar, which is the mechanism by which journal and accounting dates are resolved to a period. In EBS 12.1.1 and 12.2.2 the object is owned by APPS and is reported as VALID.

Underlying Base Objects

ETRM metadata documents the following referenced objects: FND_PROFILE (package), GL_DATE_PERIOD_MAP (synonym), GL_LOOKUPS (view), GL_PERIODS (synonym), GL_PERIOD_STATUSES (synonym), GL_SETS_OF_BOOKS (view), PA_IMPLEMENTATIONS (synonym), PA_PERIODS_V (view), PA_PERIOD_PROCESS_PKG (package), PA_REP_SEQ_NUMBER (synonym), and PA_REP_YEAR_CAL_V (view).

  • PA_IMPLEMENTATIONS supplies the set of books, the PA period type, and the application identifier used throughout the joins.
  • GL_SETS_OF_BOOKS and GL_PERIODS anchor the GL period set and accounting period type.
  • GL_PERIOD_STATUSES restricts and qualifies periods by closing status; the view filters CLOSING_STATUS through GL_LOOKUPS (lookup type CLOSING_STATUS) to values C, F, N, O, and P.
  • GL_DATE_PERIOD_MAP resolves the period type, name, and period set used by the GL branch.
  • PA_PERIODS_V and PA_PERIOD_PROCESS_PKG drive the PA and quarter branches, with PA_PERIOD_PROCESS_PKG.APPLICATION_ID used as the application filter and 275 as the GL period-status application identifier.

Key Columns

  • Period source indicator — a literal returning 'GL', 'PA', or 'QR', identifying which calendar the row derives from.
  • PERIOD_YEAR — the accounting period year for the row.
  • PERIOD_NAME — the period name; for the quarter branch this is derived from QUARTER_NUM.
  • START_DATE / END_DATE — the beginning and ending dates of the period, taken from GL_PERIODS for GL and quarter rows and from PA_START_DATE/PA_END_DATE for PA rows.

Common Use Cases and Queries

Typical use is to align Projects reporting periods with GL or quarter boundaries, or to drive date-range selection in custom reports.

  • Listing all GL periods for the current implementation with their boundaries.
  • Deriving quarter start and end dates for aggregation reporting.
  • Resolving a period name to its dates for intercompany or cross-charge processing.
SELECT period_name, start_date, end_date
FROM   apps.pa_rep_period_dates_v
WHERE  period_year = :p_year
AND    period_name = :p_period;