Results for “user_rank”

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

Overview

The view FPA_AW_PROJ_FIN_METRICS_V is an Oracle E-Business Suite database object owned by the APPS schema and registered as VALID. It belongs to the FPA (Project Portfolio Analysis) product family, which is the analytic layer of Oracle Projects used to evaluate, rank, and select candidate projects against constrained funding. The view exposes project-level financial metrics that have been pre-calculated and materialized inside the FPA analytic workspace (AW), presenting them through a relational interface so that they can be queried with ordinary SQL rather than through OLAP API calls.

Its role is therefore a reporting and integration bridge. Rather than forcing report developers, Discoverer workbooks, or downstream extracts to navigate the multidimensional AW directly, the view flattens the AW measures into rows of scalar columns keyed by project and scenario. This makes portfolio financial data available to standard EBS reporting tools, concurrent programs, and custom interfaces without requiring AW-specific navigation logic.

The user search phrase "financial modeling group project removed" suggests confusion regarding projects that no longer appear. The view filters on SCENARIO_PROJECT_VALID = 1, meaning a scenario/project combination that has been invalidated or excluded from the current portfolio run will silently drop out of the result set. A "removed" project is, in practice, a project whose SCENARIO_PROJECT_VALID flag is no longer 1.

Underlying Base Objects

The documented dependencies for this view are the package APPS.FPA_UTILITIES_PVT and the synonym OLAP_TABLE. The view is not defined over conventional relational tables; instead, its text wraps an OLAP_TABLE invocation that dereferences the AW space name returned by FPA_UTILITIES_PVT.AW_SPACE_NAME. A literal "DURATION QUERY" cursor is passed, and the AW is told which dimensions, attributes, and measures to project into a relational shape.

The target row type is FPA_PROJ_METRICS_TBL. Dimensions mapped include SCENARIO (from SCENARIO_D) and PROJECT (from PROJECT_D). Attributes mapped from the AW include CLASS_CODE, CURRENT_FUNDING_STATUS, and RECOMMENDED_FUNDING_STATUS, each drawn from their respective AW relational sources. Measures mapped include FUNDS_REQUIRED, TOTAL_BENEFIT, SUNK_COST, TOTAL_COST, USER_RANK, NET_PRESENT_VALUE, INTERNAL_RATE_RETURN, RETURN_ON_INV, FIN_PERCENTILE, STR_PERCENTILE, RISK_PERCENTILE, INVESTMENT_INDEX, PAYBACK_PERIOD, and SCENARIO_PROJECT_VALID. Because the view depends on a package function returning the AW space name, its results are valid only after the FPA AW has been built and populated.

Key Columns

• PROJECT and SCENARIO — the composite key identifying which project is being evaluated under which analysis scenario.
• CLASS_CODE — the project classification used for grouping and portfolio segmentation.
• FUNDS_REQUIRED, TOTAL_COST, SUNK_COST — cost-side measures; SUNK_COST is notably project-level rather than scenario-level, reflecting spend already committed.
• TOTAL_BENEFIT — the aggregate benefit measure for the scenario/project combination.
• NET_PRESENT_VALUE, INTERNAL_RATE_RETURN, RETURN_ON_INV, INVESTMENT_INDEX, PAYBACK_PERIOD — standard capital-budgeting metrics used for ranking and selection.
• USER_RANK — the manually maintained ranking, distinct from computed financial scores.
• FIN_PERCENTILE, STR_PERCENTILE, RISK_PERCENTILE — normalized percentile scores across the financial, strategic, and risk dimensions of the scoring model.
• RECOMMENDED_FUNDING_STATUS and CURRENT_FUNDING_STATUS — attributes indicating the funding decision suggested by the analysis versus the status currently recorded.
• SCENARIO_PROJECT_VALID — the visibility flag; only rows equal to 1 are returned.

Common Use Cases and Queries

Typical usage includes portfolio scorecards, funding recommendation extracts, and reconciliation between FPA analysis results and the operational project records. A basic listing ordered by score is shown below.

• SELECT project, scenario, net_present_value, internal_rate_return, investment_index, payback_period FROM fpa_aw_proj_fin_metrics_v WHERE fin_percentile > 50 ORDER BY investment_index DESC;
• SELECT project, scenario, total_cost, total_benefit, sunk_cost, recommended_funding_status FROM fpa_aw_proj_fin_metrics_v WHERE scenario = :p_scenario;
• SELECT class_code, COUNT(*), AVG(fin_percentile) FROM fpa_aw_proj_fin_metrics_v GROUP BY class_code;

When a project appears to have been removed from a report, querying without the built-in filter—against the AW or by testing SCENARIO_PROJECT_VALID directly—will confirm whether the row still exists with a flag of 0. Note that the view is data-dependent on the FPA analytic workspace; if the AW has not been refreshed, the view may return stale or empty results.