Search Results fpa_scenario_tbl




Overview
Explore in AI Chat

Overview

FPA_AW_SCES_V is an Oracle Applications (APPS) view in the Enterprise Territory Management (ETRM) / Fusion Predictive Applications (FPA) schema. In Oracle EBS 12.1.1 and 12.2.2, it exposes scenario-to-planning-cycle associations that are stored in an Oracle OLAP analytic workspace rather than in conventional relational tables. The view presents two columns — scenario and planning_cycle — and it is the primary relational access point for determining which planning cycle a given scenario belongs to.

Because ETRM planning, forecasting, and territory alignment processes are organized by planning cycle (for example, a quarterly or annual cycle), this view provides the mapping that downstream reports and concurrent programs use to scope their results. The view is defined entirely over an analytic workspace reference and therefore returns no rows unless the underlying OLAP workspace (identified by FPA_UTILITIES_PVT.AW_SPACE_NAME) has been built and populated.

Underlying Base Objects

The view is defined over the following documented objects:

  • FPA_UTILITIES_PVT (PL/SQL package) — provides the AW_SPACE_NAME constant/function that resolves the name of the OLAP analytic workspace at runtime, followed by the literal suffix ' duration query'.
  • OLAP_TABLE (synonym) — the Oracle OLAP table function that materializes multidimensional workspace data into rows and columns, using an OLAP DML command string as the query specification.

The view text is:

SELECT scenario, planning_cycle FROM TABLE (OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' duration query', 'FPA_SCENARIO_TBL', '', 'DIMENSION scenario FROM scenario_d WITH ATTRIBUTE planning_cycle from planning_cycle_scenario_r'))

Within the OLAP query string, scenario is drawn from the scenario_d dimension, and planning_cycle is fetched as an attribute from the planning_cycle_scenario_r relation. The FPA_SCENARIO_TBL object acts as the target/output table type for the OLAP_TABLE call.

Key Columns

  • scenario — the scenario identifier (typically the scenario dimension member value or its descriptive name). This corresponds to a planning or simulation scenario defined in the analytic workspace.
  • planning_cycle — the planning cycle to which the scenario is assigned, retrieved as a relation attribute. Planning cycles group scenarios by time period or business planning horizon.

Common Use Cases and Queries

Typical uses include validating scenario-to-cycle assignments for planning and forecasting, and joining the view to relational scenario tables for reporting. The most direct query is:

SELECT scenario, planning_cycle FROM apps.fpa_aw_sces_v;

To retrieve only the scenarios belonging to a specific cycle (the "planning_cycle" lookup):

SELECT scenario FROM apps.fpa_aw_sces_v WHERE planning_cycle = :p_cycle;

To count scenarios per cycle and detect misconfigured or unassigned scenarios:

SELECT planning_cycle, COUNT(*) FROM apps.fpa_aw_sces_v GROUP BY planning_cycle ORDER BY planning_cycle;

Because the source is an OLAP_TABLE call, the view is read-only and depends on the analytic workspace being available; query failures generally indicate that the workspace has not been built or that the OLAP session context is missing. It should not be used as a substitute for ETRM base tables in transactional or update logic.