Search Results quarter_number




Overview
Explore in AI Chat

Overview

APPS.FPA_AW_QUARTER_ATTS_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 view that exposes quarter-level calendar attributes sourced from an Oracle OLAP analytic workspace maintained by the Enterprise Territory Management and related forecasting/planning modules. Rather than reading from a conventional relational table, the view is defined over an OLAP_TABLE construct, which means that its rows are materialized at query time by invoking a stored program that maps OLAP dimension members and attributes into a relational row-and-column format.

The view's purpose is to present the quarterly hierarchy of the fiscal calendar in a form that standard SQL, concurrent programs, and BI Publisher reports can consume. It is typically referenced indirectly by Oracle's packaged reporting logic rather than being joined by end users, but it remains queryable directly in read-only fashion by technical consultants and developers who need quarter-level metadata.

Underlying Base Objects

The documented base objects referenced by this view are:

  • FPA_UTILITIES_PVT (PL/SQL package) — supplies the AW_SPACE_NAME function, which returns the name of the currently attached analytic workspace. This is concatenated with the literal ' DURATION QUERY' to form the OLAP query name passed to OLAP_TABLE.
  • OLAP_TABLE (synonym) — the Oracle OLAP function that converts an analytic workspace query result into a relational row set. It accepts the workspace query name, the output table type (FPA_QUARTER_TBL), an optional limit-map expression (CALL LMT_YEAR_PRG('QUARTER')), and an attribute list mapping each output column to an OLAP dimension or attribute.

Because the view depends on OLAP_TABLE and on an active analytic workspace, querying it requires the OLAP option to be installed and the FPA workspace to be attached and available in the session. Without that context, the view returns no rows or fails to parse.

Key Columns

  • CAL_HIER — the calendar hierarchy identifier, mapped to the CAL_PERIOD_TYPE_D dimension. It distinguishes among the calendar hierarchies available in the workspace (for example, fiscal versus reporting hierarchies).
  • QUARTER — the quarter member itself, mapped to the TIME_D dimension, representing the named quarter (such as 2024-Q1).
  • QUARTER_PARENT — the parent of the quarter in the quarterly hierarchy, derived from CALENDAR_HIERARCHY_H. This supports roll-up navigation to the year (or higher) level.
  • QUARTER_NUMBER — the numeric identifier for the quarter, sourced from TIME_TIME_IDENTIFIER_R. This is the attribute most frequently searched for, since it provides a sortable integer key (typically 1 through 4) for ordering and grouping quarterly data.
  • START_DATE — the quarter start date, sourced from the START_DATE_QUARTER_R relation, useful for date-window filtering and period comparisons.

Common Use Cases and Queries

Typical uses include validating fiscal calendar setup, driving forecast and territory reports that must sequence periods by quarter, and joining quarterly facts to a lightweight quarter reference for labeling.

  • Retrieve all quarters with their sequence number: SELECT quarter, quarter_number, start_date FROM apps.fpa_aw_quarter_atts_v ORDER BY quarter_number;
  • Filter to a specific hierarchy: SELECT * FROM apps.fpa_aw_quarter_atts_v WHERE cal_hier = :p_hierarchy;
  • Resolve a parent for roll-up: SELECT quarter, quarter_parent FROM apps.fpa_aw_quarter_atts_v WHERE quarter_number = :q;

Because the source is an OLAP-backed view, avoid unbounded scans in interactive sessions; apply predicates on CAL_HIER, QUARTER_NUMBER, or START_DATE where possible, and confirm the analytic workspace is attached before relying on results.