Search Results initiate_date




Overview
Explore in AI Chat

Overview

The FPA_AW_PC_INFO_V view resides in the APPS schema and belongs to the FPA (Project Portfolio Analysis) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes planning cycle header information maintained in the Project Portfolio Analysis analytical workspace, presenting each planning cycle alongside its associated portfolio, status, calendar, currency, and funding attributes. The view functions as a relational projection over a multidimensional analytic workspace (AW), converting OLAP cube data into a conventional row/column result set that can be queried with standard SQL. This design allows reporting tools, concurrent programs, and integration interfaces to consume portfolio planning metadata without interacting directly with the AW expression language.

Because the object depends on an external analytic workspace and a PL/SQL package, its status is reported as INVALID in the data dictionary until the AW structures are successfully resolved at runtime. The CONVERSION_RATE_TYPE column, which is the term most frequently associated with this view, is surfaced here as a measure drawn from the underlying planning cycle currency configuration.

Underlying Base Objects

The view is not defined over ordinary relational tables. Instead, its text invokes OLAP_TABLE, an Oracle synonym for the OLAP table function, passing the analytic workspace name assembled by FPA_UTILITIES_PVT.AW_SPACE_NAME. Two documented base objects are referenced:

  • FPA_UTILITIES_PVT (PACKAGE) — supplies the AW space name and other Project Portfolio Analysis utilities that bind the view to the correct workspace instance.
  • OLAP_TABLE (SYNONYM) — the table function that materializes AW dimensions, attributes, and measures into queryable columns using the 'FPA_PC_INFO_TBL' type specification.

Dimensions such as PLANNING_CYCLE, a DURATION QUERY limit, and measure mappings (PC_FUNDING_PERIOD_FROM_M, PC_CURRENCY_M, PC_CONVERSION_RATE_TYPE_M, and others) define how AW members translate into result-set rows.

Key Columns

Common Use Cases and Queries

Typical usage includes identifying the active planning cycle per portfolio, auditing currency conversion settings, and feeding downstream reports. A representative query is:

  • SELECT PLANNING_CYCLE, PORTFOLIO, PC_STATUS, CURRENCY_CODE, CONVERSION_RATE_TYPE, CONVERSION_RATE_DATE FROM APPS.FPA_AW_PC_INFO_V WHERE CURRENCY_CODE IS NOT NULL;
  • SELECT PLANNING_CYCLE, PORTFOLIO, SCENARIO_COUNT FROM APPS.FPA_AW_PC_INFO_V WHERE LAST_FLAG = 'Y';

Because the view depends on an initialized analytic workspace, queries may fail with ORA errors if the AW has not been loaded. Sessions requiring the view should therefore run only after the Project Portfolio Analysis workspace initialization has completed.