Search Results scenario_class_code_funds_req_m




Overview
Explore in AI Chat

Overview

The FPA_AW_PCLASS_FUNDS_V view is an Oracle E-Business Suite database object owned by the APPS schema and associated with the FPA – Project Portfolio Analysis product. It exposes project-class-level funding and benefit analysis data that originates from an Oracle OLAP analytic workspace rather than from conventional relational base tables. In EBS 12.1.1 and 12.2.2, this view serves reporting, integration, and dashboard consumption needs within the Project Portfolio Analysis module, allowing funds availability, funds requirements, and variance figures to be queried through a standard SQL interface layered over multidimensional analytic data.

The view is documented as INVALID. An invalid status indicates the view failed compilation or validation at the time of metadata extraction, typically because a referenced object changed, was recompiled, or became inaccessible. Because the definition depends on a runtime-constructed OLAP workspace name, invalid status is not uncommon and may resolve after a successful recompilation or OLAP process execution. Service requests referencing "funds_required" frequently trace to this view when users attempt to report on funding shortfalls by project classification.

Underlying Base Objects

The documented referenced base objects are FPA_UTILITIES_PVT (PACKAGE) and OLAP_TABLE (SYNONYM). The view is not built on ordinary relational tables. Instead, it uses the OLAP_TABLE table function, passing an analytic workspace name assembled at runtime by FPA_UTILITIES_PVT.AW_SPACE_NAME concatenated with the literal string ' DURATION QUERY'. The table function maps the OLAP workspace into a relational row set shaped against the return type FPA_PROJ_CLASS_TBL, which is a user-defined object type that defines the column layout.

The OLAP mapping declares dimensions and measures:

All rows are filtered by the predicate WHERE SCE_CLASS_CODE_VALID = 1, restricting output to valid scenario/class combinations.

Key Columns

  • CLASS_CODE — Project classification identifier used to group projects for portfolio analysis.
  • SCENARIO — The portfolio analysis scenario under evaluation.
  • PLANNING_CYCLE — Planning cycle attribute associated with the scenario, enabling time-based comparison.
  • FUNDS_AVAILABLE — Funds available for the class/scenario combination.
  • FUNDS_REQUIRED — Funds required against the class/scenario; this is the column most closely tied to the "funds_required" search term.
  • FUNDING_VARIANCE — The difference between available and required funds, indicating surplus or shortfall.
  • TOTAL_BENEFIT — Aggregate benefit measure at the class/scenario level.
  • SCE_CLASS_CODE_VALID — Validity flag; the view exposes only rows where this equals 1.

Common Use Cases and Queries

Typical usage includes funding-gap reporting, class-level budget comparisons, and scenario-driven portfolio reviews. A representative query retrieves funding requirements and related facts for a scenario:

  • SELECT class_code, scenario, planning_cycle, funds_available, funds_required, funding_variance, total_benefit FROM apps.fpa_aw_pclass_funds_v WHERE scenario = :scenario;
  • Comparing available versus required funds: SELECT class_code, funds_required, funds_available, funding_variance FROM apps.fpa_aw_pclass_funds_v ORDER BY class_code;

Because the view is reported INVALID and depends on OLAP runtime components, remediation should include recompiling the view (ALTER VIEW APPS.FPA_AW_PCLASS_FUNDS_V COMPILE;) and verifying that the analytic workspace referenced by FPA_UTILITIES_PVT.AW_SPACE_NAME exists and is populated. Effective privileges on OLAP_TABLE, FPA_UTILITIES_PVT, and the underlying OLAP analytic workspace are prerequisites for successful execution in both 12.1.1 and 12.2.2 environments.