Results for “approved_flag”

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

Overview

FPA_AW_SCE_INFO_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the FPA – Project Portfolio Analysis product. It exposes scenario-level planning information held in an Oracle OLAP analytic workspace and presents it as a conventional relational result set, allowing standard SQL tools, concurrent programs, and report templates to query OLAP-resident scenario attributes without issuing native OLAP DML. The view surfaces descriptive and analytical scenario metadata: the scenario identifier, its planning cycle, recommendation and approval indicators, initial and working scenario flags, and the discount, funding, and funds-required measures associated with each scenario. Because the view is documented as INVALID in the ETRM metadata, DBAs should recompile or validate it prior to reliance, since an invalid view will raise ORA-04063 or ORA-00904 errors on access.

Underlying Base Objects

The view is defined over an inline table function invocation of OLAP_TABLE, the standard Oracle OLAP relational bridge, whose first argument is built from FPA_UTILITIES_PVT.AW_SPACE_NAME concatenated with a fixed ' DURATION QUERY' string. Two referenced base objects are documented: the package FPA_UTILITIES_PVT and the synonym OLAP_TABLE. FPA_UTILITIES_PVT supplies the analytic workspace name used at runtime, while OLAP_TABLE translates OLAP cube dimensions and measures into rows and columns. The dimension mapping assigns SCENARIO from SCENARIO_D with an attribute PLANNING_CYCLE drawn from PLANNING_CYCLE_SCENARIO_R. Measures are mapped as IS_INITIAL_SCENARIO from SCENARIO_INITIAL_M, IS_WORKING_SCENARIO from SCENARIO_WORKING_M, RECOMMENDED_FLAG from SCENARIO_RECOMMENDED_FLAG_M, APPROVED_FLAG from SCENARIO_APPROVED_FLAG_M, DISCOUNT_RATE from SCENARIO_DISCOUNT_RATE_M, FUNDS_AVAILABLE from SCENARIO_FUNDING_M, and FUNDS_REQUIRED from SCENARIO_FUNDS_REQ_M.

Key Columns

The view exposes nine columns, each corresponding to an OLAP dimension value or measure:

• SCENARIO – the scenario dimension member identifier, the primary row key.
• PLANNING_CYCLE – the planning cycle attribute related to the scenario.
• RECOMMENDED_FLAG – indicates whether the scenario has been recommended.
• APPROVED_FLAG – the approval status of the scenario; this column is the one most often referenced by users searching for approved scenarios in portfolio analysis.
• IS_INITIAL_SCENARIO – identifies the seeded baseline scenario.
• IS_WORKING_SCENARIO – identifies the scenario currently designated as the working copy.
• DISCOUNT_RATE – the financial discount rate applied within the scenario.
• FUNDS_AVAILABLE – funding availability measure for the scenario.
• FUNDS_REQUIRED – funding requirement measure for the scenario.

Common Use Cases and Queries

Typical usage centers on identifying approved or recommended scenarios, distinguishing the initial and working scenarios, and reporting funding gaps. A simple listing returns all scenarios with their flags and funding measures:

SELECT scenario, planning_cycle, approved_flag, recommended_flag, funds_available, funds_required FROM apps.fpa_aw_sce_info_v;

To isolate approved scenarios for a given planning cycle:

SELECT scenario, planning_cycle, discount_rate FROM apps.fpa_aw_sce_info_v WHERE approved_flag = 'Y' AND planning_cycle = :p_cycle;

A funding gap query compares available and required funds:

SELECT scenario, funds_available, funds_required, (funds_available - funds_required) net_position FROM apps.fpa_aw_sce_info_v WHERE is_working_scenario = 'Y';

Because the view depends on OLAP_TABLE and the analytic workspace name supplied by FPA_UTILITIES_PVT, queries require that the analytic workspace be attached and that the view be valid. Confirm validity with SELECT status FROM dba_objects WHERE object_name = 'FPA_AW_SCE_INFO_V'; and recompile through adadmin or ALTER VIEW COMPILE if the status remains INVALID.