Search Results pa_fcst_project_list_v




Overview
Explore in AI Chat

Overview

PA_FCST_PROJECT_LIST_V is an Oracle E-Business Suite Projects (PA) module view owned by the APPS schema. Its documented purpose is to present the list of projects available for forecasting, exposing a project-oriented record set that combines project master data, customer information, project manager or party details, probability information, and implementation context. The view is used by the Project Forecasting and budgeting functionality where users must select a project before forecasting periods may be maintained. In the Oracle EBS 12.1.1 and 12.2.2 releases, this object typically appears as a supporting view for Forecast (PA_FCST) forms and related concurrent programs, and is commonly referenced in troubleshooting and extension work where developers search for "pa_fcst_project_list_v" to understand which project rows are eligible for forecasting.

Underlying Base Objects

The view text joins several documented base objects. The principal project source is PA_PROJECTS_ALL, aliased PPA, supplying project identifiers, number, name, currency, organization, type, status, and date information. Customer names are derived through the PA_PROJECTS_MAINT_UTILS package function GET_PRIMARY_CUSTOMER_NAME, restricted to the first 45 characters. Probability percentage and probability member information comes from PA_PROBABILITY_MEMBERS. Party and person associations are drawn from PA_PROJECT_PARTIES and PER_ALL_PEOPLE_F, while security and menu-related filtering references FND_GRANTS, FND_OBJECTS, FND_MENUS, WF_ROLES, and FND_GLOBAL. Implementation and ledger context are supplied by PA_IMPLEMENTATIONS_ALL and GL_SETS_OF_BOOKS. Additional inline subqueries call the PA_FCST_GLOBAL package, using functions such as ISCROSSPROJECTVIEWUSER, GETPROJECTNUMBER, GETPROJECTNAME, GETPROJTYPE, GETPROJECTORGID, GETPROJECTSTARTDATE, GETPROJECTCOMPDATE, GETPROJECTMANGERNAME, and GETPERIODSETNAME. FND_GLOBAL, PA_UTILS, PA_PROJECT_PLAYERS, and DUAL are also documented as referenced objects.

Key Columns

Common Use Cases and Queries

This view is most often queried to list projects that a given user may forecast, or to restrict forecasting selections to a specific project number, customer, or status. A typical inquiry is:

SELECT project_id, project_number, project_name, customer_name, project_status_code FROM pa_fcst_project_list_v WHERE project_number = :project_number;

Another common pattern filters by status and person to populate a selection list:

SELECT project_id, project_name, person_name FROM pa_fcst_project_list_v WHERE project_status_code = 'APPROVED' AND person_id = :person_id ORDER BY project_number;

Because the view embeds calls to PA_FCST_GLOBAL and PA_PROJECTS_MAINT_UTILS, performance depends on package execution and security filtering. When extending or diagnosing the Forecast project list, the view should be treated as a read-only, security-aware source rather than a base table.