Search Results project_num




Overview
Explore in AI Chat

Overview

PA_FCST_PROJ_INFO_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented in Oracle's ETRM (E-Business Suite Technical Reference Manual) with the description "a view that shows project information." It exposes a narrow, denormalized slice of project master data together with a probability weighting value, joining the project definition stored in PA_PROJECTS_ALL to the forecast probability setup held in PA_PROBABILITY_MEMBERS. The view is primarily used in forecasting, pipeline, and probability-weighted reporting contexts where a project identifier, name, currency, project number, and probability percentage must be retrieved in a single query without navigating the full PA_PROJECTS_ALL structure.

Its compact column list (PROJECT_ID, PROJECT_CURRENCY, PROJECT_NAME, PROJECT_NUM, PROB_PER) makes it a lightweight informational view rather than a transactional or accounting view. It is most relevant to forecast and pipeline reporting functions and to integration points that need a minimal project descriptor set.

Underlying Base Objects

The documented base objects referenced by the view are PA_PROJECTS_ALL (accessed via a synonym) and PA_PROBABILITY_MEMBERS (also via a synonym). The view text joins them as follows:

  • PA_PROJECTS_ALL is aliased as P1 and provides PROJECT_ID, PROJFUNC_CURRENCY_CODE, NAME, SEGMENT1, and the join key PROBABILITY_MEMBER_ID.
  • PA_PROBABILITY_MEMBERS is aliased as P2 and supplies PROBABILITY_PERCENTAGE, joined on P1.PROBABILITY_MEMBER_ID = P2.PROBABILITY_MEMBER_ID.
  • The probability join is an outer join (P2.PROBABILITY_MEMBER_ID(+)), so projects without an assigned probability member are still returned, with PROB_PER null.

PA_PROJECTS_ALL is the core project definition table holding both project and (as the "_ALL" suffix implies) its translated/multi-org variants; the view does not filter by org, so results reflect the underlying table's rows. PA_PROBABILITY_MEMBERS holds probability member definitions and the associated percentage used to weight forecast amounts. Because the join is outer, the view returns one row per project row, enriched where a probability member exists.

Key Columns

  • PROJECT_ID — Surrogate primary key of the project, taken from P1.PROJECT_ID. Used for joins to other PA tables and to foreign keys throughout the applications.
  • PROJECT_CURRENCY — The project functional currency code, sourced from P1.PROJFUNC_CURRENCY_CODE. Identifies the currency in which project amounts are expressed.
  • PROJECT_NAME — The descriptive project name from P1.NAME.
  • PROJECT_NUM — The user-facing project number, sourced from P1.SEGMENT1. This is the value returned when a user searches on "project_num"; it is the human-readable identifier rather than the internal PROJECT_ID.
  • PROB_PER — The probability percentage from P2.PROBABILITY_PERCENTAGE, used to weight forecast or pipeline values. Null when no probability member is assigned.

Common Use Cases and Queries

A frequent requirement is to resolve a project number to its internal ID and probability, since SEGMENT1 is the business key users search on. A typical lookup by project_num is:

  • SELECT project_id, project_num, project_name, project_currency, prob_per FROM apps.pa_fcst_proj_info_v WHERE project_num = :project_num;

Forecast and pipeline reporting often needs the probability weight to compute weighted values:

  • SELECT project_num, project_name, prob_per, prob_per/100 weighted_factor FROM apps.pa_fcst_proj_info_v WHERE prob_per IS NOT NULL;

Currency-aware listings use PROJECT_CURRENCY to group or filter:

  • SELECT project_currency, COUNT(*) FROM apps.pa_fcst_proj_info_v GROUP BY project_currency;

Because the view performs no organizational or status filtering, it should be treated as a convenience access path. For full project attributes, statuses, or organization security, query PA_PROJECTS_ALL directly or join this view back to it on PROJECT_ID. All access should be granted through APPS synonyms and standard PA security, consistent with Project Accounting reporting practice.

  • View: PA_FCST_PROJ_INFO_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FCST_PROJ_INFO_V,  object_name:PA_FCST_PROJ_INFO_V,  status:VALID,  product: PA - Projects ,  description: PA_FCST_PROJ_INFO_V is a view that shows project information ,  implementation_dba_data: APPS.PA_FCST_PROJ_INFO_V , 

  • View: PA_FCST_PROJ_INFO_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FCST_PROJ_INFO_V,  object_name:PA_FCST_PROJ_INFO_V,  status:VALID,  product: PA - Projects ,  description: PA_FCST_PROJ_INFO_V is a view that shows project information ,  implementation_dba_data: APPS.PA_FCST_PROJ_INFO_V , 

  • View: PA_PROJ_ADJUSTMENTS_VIEW 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_ADJUSTMENTS_VIEW,  object_name:PA_PROJ_ADJUSTMENTS_VIEW,  status:VALID,  product: PA - Projects ,  description: Adjustment activity on expenditure items for a project. ,  implementation_dba_data: APPS.PA_PROJ_ADJUSTMENTS_VIEW , 

  • View: PA_PROJ_ADJUSTMENTS_VIEW 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_ADJUSTMENTS_VIEW,  object_name:PA_PROJ_ADJUSTMENTS_VIEW,  status:VALID,  product: PA - Projects ,  description: Adjustment activity on expenditure items for a project. ,  implementation_dba_data: APPS.PA_PROJ_ADJUSTMENTS_VIEW , 

  • View: PA_PROJ_EXPEND_MRC_VIEW 12.1.1

    product: PA - Projects ,  description: Expenditure items for projects, which includes cost and revenue. PA_PROJ_EXPEND_VIEW is a view of all project expenditure items. This view displays all relevant information for all expenditure items, including labor, expense reports, usages ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_CINT_TXN_DETAILS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CINT_TXN_DETAILS_V,  object_name:PA_CINT_TXN_DETAILS_V,  status:VALID,  product: PA - Projects ,  description: This is an Internal view created for Generate Capitalized interest Transaction process ,  implementation_dba_data: APPS.PA_CINT_TXN_DETAILS_V , 

  • View: PA_CINT_TXN_DETAILS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CINT_TXN_DETAILS_V,  object_name:PA_CINT_TXN_DETAILS_V,  status:VALID,  product: PA - Projects ,  description: This is an Internal view created for Generate Capitalized interest Transaction process ,  implementation_dba_data: APPS.PA_CINT_TXN_DETAILS_V , 

  • View: PA_PROJ_EXPEND_VIEW 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_EXPEND_VIEW,  object_name:PA_PROJ_EXPEND_VIEW,  status:VALID,  product: PA - Projects ,  description: Expenditure items for projects, which includes cost and revenue. PA_PROJ_EXPEND_VIEW is a view of all project expenditure items. This view displays all relevant information for all expenditure items, including labor, expense reports, usage ,  implementation_dba_data: APPS.PA_PROJ_EXPEND_VIEW , 

  • View: PA_PROJ_EXPEND_VIEW 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_EXPEND_VIEW,  object_name:PA_PROJ_EXPEND_VIEW,  status:VALID,  product: PA - Projects ,  description: Expenditure items for projects, which includes cost and revenue. PA_PROJ_EXPEND_VIEW is a view of all project expenditure items. This view displays all relevant information for all expenditure items, including labor, expense reports, usage ,  implementation_dba_data: APPS.PA_PROJ_EXPEND_VIEW , 

  • View: PA_PROJ_EXPEND_MRC_VIEW 12.2.2

    product: PA - Projects ,  description: Expenditure items for projects, which includes cost and revenue. PA_PROJ_EXPEND_VIEW is a view of all project expenditure items. This view displays all relevant information for all expenditure items, including labor, expense reports, usages ,  implementation_dba_data: Not implemented in this database ,