Search Results quarter_parent

Overview

FPA_AW_QUARTER_ATTS_V is a PL/SQL-based view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the FPA (Project Portfolio Analysis) product family. It exposes quarter-level time dimension attributes that are dynamically materialized at runtime from an Oracle OLAP analytic workspace rather than from a conventional relational table. The view is defined using the OLAP_TABLE table function, which maps an OLAP dimension query against a typed object table (FPA_QUARTER_TBL) into a relational rowset that can be queried with standard SQL.

The view's principal role is to supply the quarter dimension members and their descriptive attributes to other FPA reporting views, dashboards, and analytic routines that reconcile project portfolio data across fiscal or calendar periods. Because the OLAP workspace name is resolved dynamically through FPA_UTILITIES_PVT.AW_SPACE_NAME, the same view definition serves any number of deployed analytic workspaces without modification.

Underlying Base Objects

The documented referenced base objects are the package APPS.FPA_UTILITIES_PVT and the synonym OLAP_TABLE. The view text concatenates the value returned by FPA_UTILITIES_PVT.AW_SPACE_NAME with the literal string ' DURATION QUERY' to form the OLAP query identifier passed as the first argument to OLAP_TABLE. The remaining arguments define the row type (FPA_QUARTER_TBL), the OLAP program invoked on the server side (CALL LMT_YEAR_PRG('QUARTER')), and the dimension and attribute mappings.

Attribute and dimension sources include CAL_PERIOD_TYPE_D (for CAL_HIER), TIME_D with the QUARTER_PARENT hierarchy (for QUARTER and QUARTER_PARENT), CALENDAR_HIERARCHY_H, and the OLAP relation objects TIME_TIME_IDENTIFIER_R and START_DATE_QUARTER_R (for QUARTER_NUMBER and START_DATE respectively). These are OLAP workspace objects, not transactional EBS tables, so the view is dependent on the integrity and availability of the analytic workspace.

Key Columns

• CAL_HIER — Calendar hierarchy identifier, sourced from the CAL_PERIOD_TYPE_D dimension; distinguishes fiscal versus calendar hierarchies.
• QUARTER — The quarter dimension member, resolved from the TIME_D dimension and forming the primary period key for this view.
• QUARTER_PARENT — The parent member in the CALENDAR_HIERARCHY_H hierarchy, typically the year to which the quarter belongs.
• QUARTER_NUMBER — The ordinal number of the quarter (for example 1 through 4) sourced from TIME_TIME_IDENTIFIER_R. This is the column matched by the search term "quarter_number" and is the attribute most often used for sorting and fiscal-period filtering.
• START_DATE — The beginning date of the quarter, sourced from START_DATE_QUARTER_R, used for date-range joins and period-to-date calculations.

Common Use Cases and Queries

Typical usage includes populating quarter selection lists in FPA portfolio analysis dashboards, aligning project cost and benefit data to fiscal quarters, and providing period metadata for period-over-period comparisons. A representative query returns the quarter labels and start dates for a given hierarchy:

SELECT cal_hier, quarter, quarter_parent, quarter_number, start_date
FROM apps.fpa_aw_quarter_atts_v
WHERE cal_hier = :p_hierarchy
ORDER BY quarter_number;

Because the view is relational in form, it can be joined to FPA fact views or to standard EBS project tables on START_DATE or QUARTER. Note that queries depend on the OLAP workspace being loaded and on FPA_UTILITIES_PVT.AW_SPACE_NAME resolving correctly for the session; if the workspace is unavailable, the view returns an ORA error at parse or fetch time rather than an empty result set.