Results for “sunk_cost”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view FPA_AW_SCE_CASHFLOWS_V is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite, delivered as part of the FPA — Project Portfolio Analysis product. Its status is documented as VALID in the ETRM repository for 12.1.1 and 12.2.2. The view exposes scenario-level cash flow metrics for analytic workspace (AW) data managed by Project Portfolio Analysis, providing a relational, SQL-queryable projection of multidimensional scenario forecasts.
Unlike conventional views defined purely over base tables, this view is an OLAP presentation view. It derives its rows from an analytic workspace through the Oracle OLAP OLAP_TABLE mechanism, which maps multidimensional measures and dimensions into a relational row/column structure. This design allows Project Portfolio Analysis scenario results — originally computed and stored in the AW — to be surfaced through standard SQL, enabling downstream reporting, integration, and custom extract development without requiring OLAP API coding.
The view presents one row per scenario, summarizing funds, benefits, and costs associated with each scenario defined in the portfolio analysis workspace.
Underlying Base Objects
The documented base objects referenced by this view are:
- FPA_UTILITIES_PVT (PL/SQL package) — supplies the AW space name via
FPA_UTILITIES_PVT.AW_SPACE_NAME, which is concatenated with the literal' DURATION QUERY'to form the OLAP DURATION QUERY used byOLAP_TABLE. - OLAP_TABLE (synonym) — the Oracle OLAP function that returns AW data as a relational row set, mapped here into the
FPA_SCE_METRICS_TBLtype.
The view is therefore not defined over conventional FPA base tables. Instead, it is a runtime bridge between the FPA analytic workspace and the relational SQL layer. The AW query resolves the dimensions and measures declared in the view text: a SCENARIO dimension mapped from SCENARIO_D, and four measures — FUNDS_REQUIRED (SCENARIO_FUNDS_REQ_M), TOTAL_BENEFIT (SCENARIO_BENEFIT_M), SUNK_COST (SCENARIO_SUNK_COST_M), and TOTAL_COST (SCENARIO_COST_M).
Key Columns
- SCENARIO — The scenario identifier or name from the
SCENARIO_Ddimension. This is the primary grouping key and identifies which portfolio analysis scenario the row describes. - FUNDS_REQUIRED — Measure sourced from
SCENARIO_FUNDS_REQ_M, representing the funding requirement projected for the scenario. - TOTAL_BENEFIT — Measure sourced from
SCENARIO_BENEFIT_M, representing the aggregate expected benefit attributed to the scenario. - SUNK_COST — Measure sourced from
SCENARIO_SUNK_COST_M, representing costs already incurred that cannot be recovered. - TOTAL_COST — Measure sourced from
SCENARIO_COST_M, representing the total cost assigned to the scenario.
Common Use Cases and Queries
Typical uses include portfolio comparison reporting, scenario benchmarking, and extraction of AW metrics into custom dashboards, concurrent programs, or interface tables. Because the view is a simple projection, it can be joined to other scenario metadata by SCENARIO.
List all scenario cash flow metrics:
SELECT SCENARIO, FUNDS_REQUIRED, TOTAL_BENEFIT, SUNK_COST, TOTAL_COST FROM APPS.FPA_AW_SCE_CASHFLOWS_V;
Rank scenarios by net position:
SELECT SCENARIO, TOTAL_BENEFIT - TOTAL_COST AS NET_POSITION FROM APPS.FPA_AW_SCE_CASHFLOWS_V ORDER BY NET_POSITION DESC;
Filter scenarios exceeding a funding threshold:
SELECT SCENARIO, FUNDS_REQUIRED FROM APPS.FPA_AW_SCE_CASHFLOWS_V WHERE FUNDS_REQUIRED > :p_amount;
As the view depends on the FPA analytic workspace, callers should invoke it in an environment where FPA is configured and the AW is attached; otherwise the OLAP_TABLE call returns no data.
-
View: FPA_AW_SCE_CASHFLOWS_V 12.2.2
APPS.FPA_AW_SCE_CASHFLOWS_V·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
View: FPA_AW_SCE_CASHFLOWS_V 12.1.1
APPS.FPA_AW_SCE_CASHFLOWS_V·↳ FPA_SCE_METRICS_TBL·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
APPS.FPA_AW_PROJ_FIN_METRICS_V·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
APPS.FPA_AW_PROJ_CASHFLOWS_V·↳ FPA_PROJ_METRICS_TBL·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
APPS.FPA_AW_PROJ_CASHFLOWS_V·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
APPS.FPA_AW_PROJ_FIN_METRICS_V·↳ FPA_PROJ_METRICS_TBL·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
eTRM - FPA Tables and Views 12.2.2
-
eTRM - FPA Tables and Views 12.1.1