Results for “scenario_initial_m”

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

Overview

APPS.FPA_AW_SCE_FIN_METRICS_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite environment (documented for 12.1.1 and 12.2.2). It belongs to the FPA — Project Portfolio Analysis product family, the module responsible for scenario-based portfolio prioritization and capital allocation. The view surfaces financial metrics calculated at the scenario level within a planning cycle, providing a relational, query-friendly presentation of data that physically resides inside an Oracle OLAP analytic workspace rather than in conventional heap tables.

Its role is to expose scenario-level funding and return figures — net present value, internal rate of return, payback period, return on investment, and funding variance — to reporting tools, concurrent programs, and integration interfaces that expect standard relational columns. In the documented metadata the object is flagged Status: INVALID, meaning it requires recompilation (typically via AD_ZD_FNDVIEW/adpatch or a manual recompile) before it can be queried reliably in a given environment.

Underlying Base Objects

The view is not defined over ordinary base tables. Its defining query uses the OLAP_TABLE function to project an Oracle OLAP analytic workspace into relational form. Two objects are documented as referenced:

• FPA_UTILITIES_PVT — the FPA utility package whose public variable AW_SPACE_NAME supplies the name of the analytic workspace at runtime. This indirection allows the view to resolve the correct AW without hard-coding environment-specific names.
• OLAP_TABLE (exposed through a synonym) — the Oracle-supplied function that materializes multidimensional data as rows and columns inside a SQL statement.

Within the OLAP_TABLE call, the workspace is instructed to return a SCENARIO_D dimension and a set of measures drawn from the scenario dimension. The dimension maps to the FPA_SCENARIO_TBL table type. Each measure named in the view text corresponds to an AW measure object, and the attribute PLANNING_CYCLE is sourced from the PLANNING_CYCLE_SCENARIO_R relation. This architecture means availability of the view depends on the FPA analytic workspace being built, refreshed, and accessible by the APPS user.

Key Columns

The view exposes fifteen columns, all resolved from the analytic workspace:

• SCENARIO — the scenario identifier, the primary dimensional key for each row.
• PLANNING_CYCLE — the planning cycle associated with the scenario, sourced as an attribute of the scenario dimension.
• RECOMMENDED_FLAG and APPROVED_FLAG — status indicators reflecting whether the scenario has been recommended and/or approved.
• IS_INITIAL_SCENARIO — measure SCENARIO_INITIAL_M; identifies the baseline scenario. This is the measure most closely associated with the search term scenario_initial_m, which appears in the view's OLAP_TABLE measure mapping.
• IS_WORKING_SCENARIO — measure SCENARIO_WORKING_M; identifies the active working scenario.
• DISCOUNT_RATE, FUNDS_AVAILABLE, FUNDS_REQUIRED, FUNDING_VARIANCE — financial parameters and funding position measures.
• PLANNED_BENEFIT, NET_PRESENT_VALUE, INTERNAL_RATE_RETURN, PAYBACK_PERIOD, RETURN_ON_INV — the investment return metrics used for portfolio ranking and comparison.

Common Use Cases and Queries

Typical uses include comparing scenario-level NPV and IRR across a planning cycle, isolating the initial versus working scenario, and feeding FPA results into custom reports or downstream integration tables.

• Retrieve the initial scenario for a planning cycle:
  SELECT scenario, planning_cycle, net_present_value, internal_rate_return
FROM apps.fpa_aw_sce_fin_metrics_v
WHERE is_initial_scenario = 'Y';
• List approved scenarios ranked by return:
  SELECT scenario, return_on_inv, payback_period
FROM apps.fpa_aw_sce_fin_metrics_v
WHERE approved_flag = 'Y'
ORDER BY return_on_inv DESC;
• Compare funding position across scenarios in a cycle:
  SELECT scenario, funds_available, funds_required, funding_variance
FROM apps.fpa_aw_sce_fin_metrics_v
WHERE planning_cycle = :cycle;

Because the view is documented as INVALID, the first remediation step in any troubleshooting effort is to recompile it and confirm the underlying FPA analytic workspace is available; otherwise queries against the view will fail with ORA-04063 or ORA-00904 class errors.