Search Results pa_fin_plan_create_plan_nobv_v




Overview
Explore in AI Chat

Overview

PA_FIN_PLAN_CREATE_PLAN_NOBV_V is an APPS-owned database view within the Oracle E-Business Suite Projects (PA) module. It is used by the Create/View/Edit Versions Oracle Applications (OA) page and retrieves information about a budget version when a budget version ID is not supplied. In other words, the view supplies the default planning attributes and preferences for a project when the user has not yet selected an existing version. The object has a VALID status and is available in EBS 12.1.1 and 12.2.2.

The view is not a transactional object; it is a presentation and integration layer that consolidates financial plan type information and project-level financial plan preferences into a single row per project and plan type. Because the plan level, time-phased, and resource list attributes differ by planning preference (cost only, revenue only, cost and revenue together, or cost and revenue separately), the view applies DECODE logic to expose the correct value for each scenario. The view does not expose a revenue_resource_list_id unconditionally; that column is populated only in the cost and revenue separate configuration, which is the key behavior to understand when querying it.

Underlying Base Objects

The ETRM metadata documents the view as being defined over three referenced base objects:

The view joins the project financial plan options (aliased PO) to the financial plan types view (aliased PT) on the financial plan type code, returning one row for each project and plan type combination.

Key Columns

Common Use Cases and Queries

Typical use is to obtain the default plan configuration for a project prior to creating a version, or to validate that a separate revenue resource list has been configured. A representative query is:

SELECT project_id, fin_plan_type_code, fin_plan_preference_code, plan_level_code, time_phased_code, cost_resource_list_id, revenue_resource_list_id, resource_list_id FROM apps.pa_fin_plan_create_plan_nobv_v WHERE project_id = :p_project_id;

To identify projects configured for separate cost and revenue planning with a distinct revenue resource list:

SELECT project_id, fin_plan_type_code, revenue_resource_list_id FROM apps.pa_fin_plan_create_plan_nobv_v WHERE fin_plan_preference_code = 'COST_AND_REV_SEP' AND revenue_resource_list_id IS NOT NULL;

Because the view depends on PL/SQL functions in PA_FIN_PLAN_CREATE_VER_GLOBAL, queries should be executed in an APPS context and are best filtered by PROJECT_ID to avoid unnecessary function invocations across large project sets.