Results for “period_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The FPA_AW_PERIOD_ATTS_V view is an APPS-owned, VALID database object within Oracle E-Business Suite, belonging to the FPA - Project Portfolio Analysis product family. It exposes period-level calendar attributes sourced from an Oracle OLAP analytic workspace, presenting them as a conventional relational result set that can be queried with standard SQL. In EBS 12.1.1 and 12.2.2, Project Portfolio Analysis relies on OLAP structures to perform multi-dimensional aggregation and "what-if" analysis across portfolios, and this view acts as the relational bridge to those dimensional definitions.

Its primary role is reporting and integration: rather than requiring callers to understand OLAP DML or invoke the analytic workspace directly, the view flattens period dimension members into rows with associated attributes such as hierarchy, parent member, sequence identifier, and date boundaries. The user search term "time_d" corresponds directly to the DIMENSION clause in the view text, where the PERIOD dimension is sourced FROM TIME_D, the analytic workspace dimension that stores period (time) members.

Underlying Base Objects

The view is defined entirely over two documented referenced objects:

• FPA_UTILITIES_PVT (PACKAGE) — supplies AW_SPACE_NAME, the runtime-resolved name of the OLAP analytic workspace. This makes the view workspace-aware and portable across environments, since physical workspace naming is constructed dynamically rather than hard-coded.
• OLAP_TABLE (SYNONYM) — the Oracle-supplied table function that materializes an OLAP query into rows and columns, bridging the dimensional model to the relational SQL engine.

Internally the view executes an OLAP_TABLE call using the LIMITMAP CALL LMT_PERIOD_PRG('PERIOD') and defines dimension and attribute mappings such as DIMENSION CAL_HIER FROM CAL_PERIOD_TYPE_D, DIMENSION PERIOD FROM TIME_D WITH HIERARCHY PERIOD_PARENT FROM CALENDAR_HIERARCHY_H, and attributes PERIOD_NUMBER FROM TIME_TIME_IDENTIFIER_R, START_DATE FROM START_DATE_PERIOD_R, and END_DATE FROM END_DATE_PERIOD_R. The OLAP_TABLE invocation is typed by FPA_PERIOD_TBL.

Key Columns

• CAL_HIER — the calendar hierarchy (calendar/period type) to which the period belongs, drawn from the CAL_PERIOD_TYPE_D dimension.
• PERIOD — the period member name, sourced from the TIME_D dimension (the target of the "time_d" search).
• PERIOD_PARENT — the parent period in the calendar hierarchy, resolved via CALENDAR_HIERARCHY_H; useful for roll-up and tree traversal.
• PERIOD_NUMBER — the numeric sequence identifier of the period (TIME_TIME_IDENTIFIER_R), enabling ordering and range comparison.
• START_DATE / END_DATE — the calendar start and end dates of the period (START_DATE_PERIOD_R and END_DATE_PERIOD_R), enabling date-range joins and reporting filters.

Common Use Cases and Queries

Typical uses include validating portfolio period definitions, joining period dates to transactional or financial reporting, and driving date-range selections in Project Portfolio Analysis integrations. Because the view is workspace-dependent, queries generally run within the APPS schema context where the FPA workspace is initialized.

List all periods and their date boundaries:

• SELECT cal_hier, period, period_number, start_date, end_date FROM apps.fpa_aw_period_atts_v ORDER BY cal_hier, period_number;

Resolve a hierarchy's parent-child structure:

• SELECT period, period_parent, period_number FROM apps.fpa_aw_period_atts_v WHERE cal_hier = :p_cal_hier ORDER BY period_number;

Identify the period covering a given date:

• SELECT period, start_date, end_date FROM apps.fpa_aw_period_atts_v WHERE :p_date BETWEEN start_date AND end_date;

These patterns illustrate the view's function as a relational window onto the OLAP time dimension for reporting and integration within Oracle EBS.