Results for “fpa_pc_discount_tbl”

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

Overview

The view FPA_AW_PC_DISC_FUNDS_V belongs to the Oracle EBS product FPA – Project Portfolio Analysis, and is owned by the APPS schema. It is a valid database view that surfaces analytical data used within the Project Portfolio Analysis planning and funding workflow. Specifically, the view exposes the planning cycle, the associated discount rate, the funding amount, and a display factor used for presentation purposes. Rather than reading from conventional relational base tables, this view is defined over an Oracle OLAP analytic workspace accessed through the OLAP_TABLE function. This design reflects the analytic nature of Project Portfolio Analysis, where scenario and portfolio computations are performed in multidimensional structures rather than in standard transactional tables.

The view therefore acts as a relational bridge: it translates multidimensional analytic workspace data into a tabular form that BI Publisher reports, Discoverer worksheets, OBIEE repositories, and custom concurrent programs or SQL-based integrations can consume. For technical consultants working in EBS 12.1.1 or 12.2.2, this view is the supported access path to the planning-cycle discount and funding figures without needing to understand OLAP DML directly.

Underlying Base Objects

The documented base objects referenced by this view are FPA_UTILITIES_PVT (a package) and OLAP_TABLE (a synonym). The view text is a single SELECT statement built on the OLAP_TABLE table function:

• FPA_UTILITIES_PVT.AW_SPACE_NAME supplies the analytic workspace name, which is concatenated with the literal ' DURATION QUERY' to form the duration query passed into OLAP_TABLE.
• FPA_PC_DISCOUNT_TBL is the OLAP table type that defines the shape of the returned rows.
• The final argument of OLAP_TABLE declares the dimension and measures, mapping the analytic workspace dimension PLANNING_CYCLE_D to the PLANNING_CYCLE column, the related attribute to PC_DISPLAY_FACTOR, and the measures PC_DISCOUNT_RATE_M and PC_FUNDING_M to the corresponding relational columns.

Because OLAP_TABLE depends on the analytic workspace being populated and available, querying this view requires that the FPA analytic workspace be properly built and the utilities package be accessible in the session. This dependency is the most common source of runtime errors during integration testing.

Key Columns

• PLANNING_CYCLE – The planning cycle (dimension member) that identifies the scenario or planning period being analyzed. This is the primary grouping key for portfolio analysis.
• PC_DISCOUNT_RATE – The discount rate associated with the planning cycle, retrieved from the PC_DISCOUNT_RATE_M measure. It is used in net-present-value and financial ranking calculations.
• PC_FUNDING – The funding amount associated with the planning cycle, retrieved from the PC_FUNDING_M measure. It represents the capital available or allocated for the cycle.
• PC_DISPLAY_FACTOR – A display-oriented attribute derived from the FACTOR_PC_R relationship, used to control how monetary or numeric values are presented in reports.

Common Use Cases and Queries

Typical uses include reporting on funding versus discount assumptions per planning cycle, validating portfolio financial parameters before running the Project Portfolio Analysis program, and extracting data into external analytical models. A representative query is:

• SELECT planning_cycle, pc_discount_rate, pc_funding, pc_display_factor FROM apps.fpa_aw_pc_disc_funds_v ORDER BY planning_cycle;
• SELECT planning_cycle, pc_funding FROM apps.fpa_aw_pc_disc_funds_v WHERE planning_cycle = '<cycle_name>';

These queries are commonly embedded in BI Publisher data templates or custom concurrent program logic to populate portfolio summary reports. When results are unexpectedly empty, the analytic workspace and OLAP table type should be verified before assuming a data or view defect.