Search Results scenario_project_valid




Overview
Explore in AI Chat

Overview

APPS.FPA_AW_PROJ_INFO_V is a reporting view in the Oracle E-Business Suite ETRM (Enterprise Tax, Treasury, and Risk Management) module, specifically within the Funding Process Accelerator (FPA) product family. The view exposes project and funding-scenario information sourced from an Oracle OLAP analytic workspace rather than from conventional relational tables. It presents a flattened, dimension-filtered projection of project-level funding status metrics, combining the recommended and current funding status for each project-to-scenario combination.

The defining characteristic of this view is its WHERE clause: WHERE SCENARIO_PROJECT_VALID = 1. This predicate restricts the result set to only those project and scenario pairings that are deemed valid by the underlying analytic measure. Consumers of the view therefore never see invalid or inactive scenario-project relationships, which simplifies downstream reporting and integration logic. A user searching for "scenario_project_valid" is almost certainly inspecting this view's filtering column or the underlying OLAP measure that drives the predicate.

Underlying Base Objects

The view is owned by APPS and is defined over two documented referenced objects:

  • OLAP_TABLE (SYNONYM) — the table function that converts OLAP workspace data into a relational row source, allowing standard SQL to query multidimensional data.
  • FPA_UTILITIES_PVT (PACKAGE) — supplies the AW_SPACE_NAME value, which identifies the analytic workspace name used in the OLAP_TABLE invocation.

The OLAP_TABLE call is parameterized as FPA_UTILITIES_PVT.AW_SPACE_NAME || ' duration query' with the analytic workspace type FPA_PROJ_METRICS_TBL. Within the OLAP expression string, dimensions are mapped as DIMENSION SCENARIO FROM SCENARIO_D and DIMENSION PROJECT FROM PROJECT_D. Measures are mapped as RECOMMENDED_FUNDING_STATUS from FUNDING_STATUS_REC_SCENARIO_PROJECT_R, CURRENT_FUNDING_STATUS from FUNDING_STATUS_CURR_PROJECT_R, and SCENARIO_PROJECT_VALID from SCENARIO_PROJECT_M. Because the source is an analytic workspace, the physical relational tables behind these dimensions and measures are not exposed at the view layer; they are resolved internally by the OLAP engine.

Key Columns

  • PROJECT — the project identifier, resolved from the project_d dimension. Serves as the primary project-side key in the result set.
  • SCENARIO — the funding scenario identifier, resolved from the scenario_d dimension. Combined with PROJECT, forms the logical grain of the view.
  • RECOMMENDED_FUNDING_STATUS — the funding status recommended by the analytic model for the given project and scenario, drawn from the funding_status_rec_scenario_project_r measure.
  • CURRENT_FUNDING_STATUS — the currently recorded funding status for the project, drawn from the funding_status_curr_project_r measure.
  • SCENARIO_PROJECT_VALID — the validity indicator from the scenario_project_m measure. Because the view filters on = 1, every returned row carries a value of 1 for this column.

Common Use Cases and Queries

The view is typically used to drive funding status dashboards, reconciliations between current and recommended funding positions, and integration extracts that must ignore invalid scenario-project pairings. A representative query retrieving all valid statuses for a single project is:

  • SELECT scenario, recommended_funding_status, current_funding_status FROM apps.fpa_aw_proj_info_v WHERE project = :p_project_id;

To compare recommended versus current funding status across all valid combinations, filtering for discrepancies:

  • SELECT project, scenario, recommended_funding_status, current_funding_status FROM apps.fpa_aw_proj_info_v WHERE recommended_funding_status <> current_funding_status;

Because the validity predicate is built into the view, callers do not need to restate the SCENARIO_PROJECT_VALID = 1 condition; it is applied implicitly for every query. Access is governed by APPS ownership, so grants or synonyms must be established for any schema other than APPS that needs to consume the view.