Search Results project_structure_version_id




Overview
Explore in AI Chat

Overview

PA_FP_BASELINED_REVENUE_V is an Oracle E-Business Suite APPS schema view owned by the Projects (PA) product family. According to its ETRM documentation, the view is used by the Maintain Versions Oracle Application (OA) page to retrieve budget versions whose version type is Revenue. Rather than serving as a general-purpose reporting object, it functions as a targeted data source for the Java-based financial plan maintenance UI, exposing only those project budget versions that have reached baselined status and belong to the Revenue plan type. In Oracle EBS 12.1.1 and 12.2.2, the view remains a read-only, VALID object delivered under the APPS schema, and its column set mirrors the attributes the Maintain Versions page requires for display, currency-style aggregation, and current/versioned plan handling.

Underlying Base Objects

The documented ETRM metadata for 12.2.2 identifies the following referenced base objects:

All access is routed through these objects; no direct base-table joins beyond PA_BUDGET_VERSIONS are documented. The WHERE clause restricts results to rows where CI_ID is null, version type equals 'REVENUE', and budget status code equals 'B' (baselined).

Key Columns

The column list begins with ROW_ID (the base row ROWID) and includes PROJECT_ID, BUDGET_VERSION_ID, VERSION_NUMBER, VERSION_NAME, VERSION_TYPE, and FIN_PLAN_TYPE_ID for identification and filtering. Quantity and revenue metrics are exposed as QUANTITY (derived from LABOR_QUANTITY), REVENUE (a DECODE-based calculation combining totals, transfers, borrowed revenue, and adjustments), TOTAL_UTILIZATION_PERCENT, TOTAL_UTILIZATION_HOURS, and TOTAL_HEAD_COUNT. Status and lifecycle indicators include BASELINED_DATE, CURRENT_FLAG, CURRENT_ORIGINAL_FLAG, RECORD_VERSION_NUMBER, PLAN_PROCESSING_CODE, REQUEST_ID, and WF_STATUS_CODE. Additional attributes include EQUIPMENT_QUANTITY, PEOPLE_QUANTITY, PROJECT_STRUCTURE_VERSION_ID, and BASELINED_BY_PERSON_NAME. The PROJECT_STRUCTURE_VERSION_ID column is central to the searched term: it identifies the project structure version associated with the baselined revenue plan, enabling callers to correlate the plan with a specific structure version. BASELINED_BY_PERSON_NAME is resolved through nested PA_FIN_PLAN_UTILS.GET_PERSON_NAME and PA_UTILS.GETEMPIDFROMUSER calls, returning the name of the user who performed the baselining.

Common Use Cases and Queries

The view is most commonly queried in conjunction with the Maintain Versions page or in diagnostic reports that need to identify baselined revenue versions for a project. A typical query filters by project and returns the current baselined revenue version along with its structure version:

SELECT project_id, budget_version_id, version_name, version_type, revenue, project_structure_version_id, baselined_date FROM pa_fp_baselined_revenue_v WHERE project_id = :p_project_id AND current_flag = 'Y';

Because the view depends on global package state (PA_FIN_PLAN_MAINT_VER_GLOBAL), direct SQL outside the OA page context may require that the session globals are initialized; otherwise results can be empty or inconsistent. Analysts therefore typically run such queries for validation and troubleshooting rather than as an alternative to the UI. For reporting, the view is valuable for listing baselined revenue versions, comparing current versus original baselines, and tracing PROJECT_STRUCTURE_VERSION_ID to the corresponding structure definition.

  • View: PA_FP_BASELINED_REVENUE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_REVENUE_V,  object_name:PA_FP_BASELINED_REVENUE_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves budget versions whose version type is Revenue ,  implementation_dba_data: APPS.PA_FP_BASELINED_REVENUE_V , 

  • View: PA_FP_BASELINED_REVENUE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_REVENUE_V,  object_name:PA_FP_BASELINED_REVENUE_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves budget versions whose version type is Revenue ,  implementation_dba_data: APPS.PA_FP_BASELINED_REVENUE_V , 

  • View: PA_FP_WORKING_REVENUE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_REVENUE_V,  object_name:PA_FP_WORKING_REVENUE_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves working budget versions whose version type is Revenue. ,  implementation_dba_data: APPS.PA_FP_WORKING_REVENUE_V , 

  • View: PA_FP_WORKING_REVENUE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_REVENUE_V,  object_name:PA_FP_WORKING_REVENUE_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves working budget versions whose version type is Revenue. ,  implementation_dba_data: APPS.PA_FP_WORKING_REVENUE_V , 

  • View: PA_FP_BASELINED_COST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_COST_V,  object_name:PA_FP_BASELINED_COST_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves all baselined budget versions whose version type is COST ,  implementation_dba_data: APPS.PA_FP_BASELINED_COST_V , 

  • View: PA_FP_WORKING_COST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_COST_V,  object_name:PA_FP_WORKING_COST_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves all working budget versions whose version type is COST. ,  implementation_dba_data: APPS.PA_FP_WORKING_COST_V , 

  • View: PA_FP_BASELINED_COST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_COST_V,  object_name:PA_FP_BASELINED_COST_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves all baselined budget versions whose version type is COST ,  implementation_dba_data: APPS.PA_FP_BASELINED_COST_V , 

  • View: PA_FP_WORKING_COST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_COST_V,  object_name:PA_FP_WORKING_COST_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves all working budget versions whose version type is COST. ,  implementation_dba_data: APPS.PA_FP_WORKING_COST_V , 

  • View: PA_FP_BASELINED_COSTREV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_COSTREV_V,  object_name:PA_FP_BASELINED_COSTREV_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves baselined budget versions, regardless of version type ,  implementation_dba_data: APPS.PA_FP_BASELINED_COSTREV_V , 

  • View: PA_FP_WORKING_COSTREV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_COSTREV_V,  object_name:PA_FP_WORKING_COSTREV_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves working budget versions, regardless of version type. ,  implementation_dba_data: APPS.PA_FP_WORKING_COSTREV_V , 

  • View: PA_FP_BASELINED_COSTREV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_BASELINED_COSTREV_V,  object_name:PA_FP_BASELINED_COSTREV_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves baselined budget versions, regardless of version type ,  implementation_dba_data: APPS.PA_FP_BASELINED_COSTREV_V , 

  • View: PA_FP_WORKING_COSTREV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WORKING_COSTREV_V,  object_name:PA_FP_WORKING_COSTREV_V,  status:VALID,  product: PA - Projects ,  description: Used in Maintain Versions OA page. This view retrieves working budget versions, regardless of version type. ,  implementation_dba_data: APPS.PA_FP_WORKING_COSTREV_V ,