Search Results weighted_score




Overview
Explore in AI Chat

Overview

The APPS.FPA_AW_PCLASS_STR_SCORES_V view is a strategic analysis reporting object within the Oracle E-Business Suite Enterprise Performance Foundation (formerly Enterprise Planning and Budgeting, and functionally aligned with ETRM / Financial Planning applications). It exposes project classification scores that have been evaluated against strategic objectives for a given scenario and planning cycle. The view is significant because it surfaces the WEIGHTED_SCORE measure — the metric most commonly queried by planners and integrators seeking to rank or filter projects by their alignment to strategic investment criteria.

Rather than storing data in a conventional relational table, the view is defined over an Oracle OLAP analytic workspace. It projects selected dimensions and measures from an OLAP cube into a relational row-and-column format so that standard SQL clients, concurrent programs, BI Publisher reports, and Discoverer workbooks can consume the data without needing OLAP-specific APIs. The view is inherently filtered: only rows where SCE_CLASS_CODE_VALID = 1 are returned, meaning the view presents the currently valid classification-to-scenario association.

Underlying Base Objects

The view does not reference ordinary base tables directly. It is defined through a call to the OLAP_TABLE function, combined with the package FPA_UTILITIES_PVT, which resolves the physical analytic workspace name at runtime. The documented referenced objects are:

  • FPA_UTILITIES_PVT (PL/SQL package) — supplies AW_SPACE_NAME, the workspace identifier prefix concatenated with the literal ' duration query' to construct the fully qualified OLAP query target.
  • OLAP_TABLE (synonym) — the standard OLAP extraction function that maps cube dimensions and measures into relational columns, using the FPA_PROJ_CLASS_STR_TBL type as the return structure.

The OLAP mapping string inside the function defines the cube dimensions CLASS_CODE_D, SCENARIO_D, PLANNING_CYCLE_SCENARIO_R, and STRATEGIC_OBJ_D, together with the measures SCENARIO_CLASS_CODE_OBJ_WSCORE_M, SCENARIO_CLASS_CODE_OBJ_CWSCORE_M, and SCENARIO_CLASS_CODE_M. Because the definition depends on runtime workspace resolution, the view is only valid when the analytic workspace is attached and the planning application is properly configured.

Key Columns

  • CLASS_CODE — the project classification identifier being scored.
  • SCENARIO — the planning or budgeting scenario under which the score was computed.
  • PLANNING_CYCLE — the cycle associated with the scenario, supplied as an attribute of the scenario dimension.
  • INVESTMENT_CRITERIA — the strategic objective or investment criterion against which the class is assessed.
  • WEIGHTED_SCORE — the primary numeric measure, derived from SCENARIO_CLASS_CODE_OBJ_WSCORE_M; represents the weighted alignment score.
  • COST_WEIGHTED_SCORE — a secondary measure from SCENARIO_CLASS_CODE_OBJ_CWSCORE_M, weighting the score by cost factors.
  • SCE_CLASS_CODE_VALID — validity flag from SCENARIO_CLASS_CODE_M; the view restricts output to records where this equals 1.

Common Use Cases and Queries

Typical usages include ranking project classifications by strategic alignment, comparing scenario outcomes, and feeding downstream prioritization reports. A representative query:

  • SELECT class_code, scenario, planning_cycle, investment_criteria, weighted_score FROM apps.fpa_aw_pclass_str_scores_v WHERE scenario = :p_scenario ORDER BY weighted_score DESC;
  • SELECT class_code, SUM(weighted_score) total_score FROM apps.fpa_aw_pclass_str_scores_v GROUP BY class_code;
  • SELECT investment_criteria, AVG(cost_weighted_score) FROM apps.fpa_aw_pclass_str_scores_v GROUP BY investment_criteria;

Because the view depends on workspace resolution through FPA_UTILITIES_PVT, queries should be executed within the correct application context and planning cycle to ensure accurate measure values.