Results for “current_funding_status”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FPA_AW_PROJ_INFO_V is an APPS-owned database view within the Oracle E-Business Suite product FPA — Project Portfolio Analysis. It exposes project-level information that has been materialized into an Oracle OLAP analytic workspace, presenting a relational projection over multidimensional data. Rather than storing rows in a conventional table, the view derives its content dynamically through the OLAP_TABLE function, which maps an analytic workspace query into a relational row-and-column result set.
The view is used primarily in Project Portfolio Analysis reporting and integration scenarios, where portfolio analysts, funding managers, and downstream reporting programs need to interrogate scenario-based project funding information. Its documented status in ETRM 12.2.2 is INVALID, meaning the view requires recompilation or its underlying dependencies (such as the analytic workspace) are not currently valid in that environment. This is significant operationally, because an invalid view cannot be queried reliably until the dependency chain is resolved.
Underlying Base Objects
The view is defined over two documented base objects: the package FPA_UTILITIES_PVT and the synonym OLAP_TABLE. The view text invokes OLAP_TABLE with an analytic workspace name resolved at runtime via FPA_UTILITIES_PVT.AW_SPACE_NAME, concatenated with the literal ' DURATION QUERY'. The OLAP_TABLE call specifies the output table type FPA_PROJ_METRICS_TBL and an empty row-to-column mapping string, followed by the analytic workspace dimension and measure mappings.
Dimensions are mapped from SCENARIO_D and PROJECT_D, and measures are mapped from FUNDING_STATUS_REC_SCENARIO_PROJECT_R, FUNDING_STATUS_CURR_PROJECT_R, and SCENARIO_PROJECT_M. Because the source is an analytic workspace rather than a base relational table, the view's validity depends not only on the package and synonym but also on the existence and structure of that workspace and its associated dimension and measure objects.
Key Columns
- PROJECT — The project dimension member, identifying the project within the portfolio analysis context.
- SCENARIO — The scenario dimension member, distinguishing funding scenarios modelled in the analytic workspace.
- RECOMMENDED_FUNDING_STATUS — A measure returning the recommended funding status for the project/scenario combination.
- CURRENT_FUNDING_STATUS — A measure returning the current funding status for the project/scenario combination.
- SCENARIO_PROJECT_VALID — A measure indicating whether the project/scenario pairing is valid. The view filters on this column with
WHERE SCENARIO_PROJECT_VALID = 1, so only valid combinations are exposed.
Common Use Cases and Queries
Typical usage involves comparing recommended versus current funding status across projects and scenarios, and validating which scenario/project pairings are meaningful. Because the view is filtered to valid combinations, it is well suited to direct reporting without additional validity checks.
A simple query returning all valid project/scenario funding information:
SELECT project, scenario, recommended_funding_status, current_funding_status FROM apps.fpa_aw_proj_info_v;
A query isolating discrepancies between recommended and current funding status:
SELECT project, scenario, recommended_funding_status, current_funding_status FROM apps.fpa_aw_proj_info_v WHERE recommended_funding_status <> current_funding_status;
A query restricted to a specific scenario:
SELECT project, current_funding_status FROM apps.fpa_aw_proj_info_v WHERE scenario = :scenario_name;
Because the view is documented as INVALID, any query should be preceded by verification of the view's compilation status in ALL_OBJECTS and, if necessary, recompilation after confirming the analytic workspace referenced by FPA_UTILITIES_PVT.AW_SPACE_NAME is available.
-
View: FPA_AW_PROJ_INFO_V 12.2.2
APPS.FPA_AW_PROJ_INFO_V·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
APPS.FPA_AW_PROJ_FIN_METRICS_V·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
View: FPA_AW_PROJ_INFO_V 12.1.1
APPS.FPA_AW_PROJ_INFO_V·↳ FPA_PROJ_METRICS_TBL·↳ 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