Search Results internal_rate_return




Overview
Explore in AI Chat

Overview

The view FPA_AW_PCLASS_FIN_METRICS_V is an Oracle E-Business Suite (EBS) reporting object owned by the APPS schema and belonging to the FPA – Project Portfolio Analysis product family. It exposes project-class-level financial metrics that are aggregated and served from an Oracle OLAP analytic workspace rather than from conventional relational tables. In EBS 12.1.1 and 12.2.2, this view functions as the presentation layer for Portfolio Analysis dashboards and analytical reporting, allowing project portfolio managers to evaluate funding positions, benefits, and investment return measures across defined project classifications and scenarios.

The view is documented as INVALID in the ETRM metadata. An invalid status indicates the underlying object dependency chain — typically the OLAP analytic workspace or the referenced package — is not in a compiled or accessible state. Because the view depends on a runtime OLAP workspace name retrieved through a PL/SQL package, invalidation commonly occurs after patch application, database migration, or when the analytic workspace has not been rebuilt. Recompilation alone will not resolve the status if the workspace itself is unavailable; the AW must be refreshed before the view can be validated.

Underlying Base Objects

The view is not defined over ordinary relational base tables. Its documented dependencies are:

  • FPA_UTILITIES_PVT (PACKAGE) — supplies the analytic workspace name through the function AW_SPACE_NAME, which is concatenated into the OLAP query string at runtime.
  • OLAP_TABLE (SYNONYM) — the Oracle OLAP table function that materializes multidimensional data into a relational row set.

The OLAP_TABLE call references the workspace, the target type FPA_PROJ_CLASS_TBL, an OLAP limit map (LMT SCENARIO_D TO SCENARIO_D), and an OLAP command string that maps dimensions (SCENARIO, CLASS_CODE) and measures to the view's columns. The measures are drawn from named OLAP variables such as SCENARIO_CLASS_CODE_FUNDING_M, SCENARIO_CLASS_CODE_NPV_M, SCENARIO_CLASS_CODE_IRR_M, and others. The outermost predicate WHERE SCE_CLASS_CODE_VALID = 1 restricts output to valid scenario/class combinations.

Key Columns

  • CLASS_CODE — the project classification dimension used to segment the portfolio.
  • SCENARIO — the analysis scenario (for example, baseline versus alternative funding models).
  • FUNDS_AVAILABLE / FUNDS_REQUIRED / FUNDING_VARIANCE — funding position measures; variance typically expresses the gap between available and required funds.
  • TOTAL_BENEFIT — aggregate projected benefit for the class/scenario.
  • NET_PRESENT_VALUE — discounted net present value.
  • INTERNAL_RATE_RETURN — the internal rate of return (IRR) measure, which is the metric most directly associated with the user's search term. This column is populated from the OLAP measure SCENARIO_CLASS_CODE_IRR_M.
  • RETURN_ON_INV — return on investment for the class/scenario.
  • PAYBACK_PERIOD — the period required to recover the investment.
  • SCE_CLASS_CODE_VALID — validity flag; only rows with value 1 are returned.

Common Use Cases and Queries

Typical use cases include portfolio-level IRR comparison across project classes, funding gap analysis, and scenario-based ranking of investment returns. A representative query is:

  • SELECT CLASS_CODE, SCENARIO, NET_PRESENT_VALUE, INTERNAL_RATE_RETURN, PAYBACK_PERIOD FROM APPS.FPA_AW_PCLASS_FIN_METRICS_V ORDER BY INTERNAL_RATE_RETURN DESC;
  • SELECT CLASS_CODE, FUNDS_REQUIRED, FUNDS_AVAILABLE, FUNDING_VARIANCE FROM APPS.FPA_AW_PCLASS_FIN_METRICS_V WHERE SCENARIO = :p_scenario;

Because the view reads from a live analytic workspace, queries should be executed after confirming the AW is built and the view is valid. If the object remains INVALID, run the FPA workspace refresh process before relying on results.