Search Results pa_fcst_project_sum_v




Overview
Explore in AI Chat

Overview

PA_FCST_PROJECT_SUM_V is a reporting view owned by the APPS schema in Oracle EBS Projects (PA). It exposes summarized project forecasting amounts at the project and budget-line level and is documented in ETRM as a VALID database object relevant to both EBS 12.1.1 and 12.2.2. The view presents forecast quantities for a project alongside identifying attributes such as the project number, project name, customer, operating organization, and ledger currency. Its purpose is to provide a convenient, query-ready projection of forecasting results without requiring callers to reconstruct the multi-table join logic that underlies the forecast summary.

A notable characteristic of the view is that it does not return a dedicated amount column per measure. Instead, a single VALUE column is produced through a DECODE driven by the profile option PA_FORECASTING_PERIOD_TYPE and the global forecasting package PA_FCST_GLOBAL. When the profile indicates revenue, the view returns probability-adjusted revenue; when it indicates cost, burdened cost; labor hours return quantity; and margin and margin percentage are computed from revenue less burdened cost. The view therefore behaves as a pivoted summary rather than a wide fact table.

Underlying Base Objects

The ETRM metadata lists the following referenced objects: FND_GLOBAL (PACKAGE), FND_PROFILE (PACKAGE), HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM), PA_BUDGET_LINES (SYNONYM), PA_BUDGET_VERSIONS (SYNONYM), PA_FCST_GLOBAL (PACKAGE), PA_FCST_PROJECT_LIST_V (VIEW), PA_PROJECTS_MAINT_UTILS (PACKAGE), PA_RESOURCE_ASSIGNMENTS (SYNONYM), PA_UTILS (PACKAGE), and DUAL (SYNONYM).

Functionally, the view joins PA_FCST_PROJECT_LIST_V to the forecast budget structures through PA_BUDGET_VERSIONS, PA_BUDGET_LINES, and PA_RESOURCE_ASSIGNMENTS, restricted to rows where the budget type is FORECASTING_BUDGET_TYPE, the current original and resource accumulated flags are set, and the assignment belongs to the matching budget version. Organization details are resolved from HR_ALL_ORGANIZATION_UNITS_TL for the carrying-out organization, and a DUAL-derived inline filter supplies the start and end dates returned by PA_FCST_GLOBAL.GETPROJFCSTSTARTDATE and GETPROJFCSTENDDATE. Profile values are fetched through FND_PROFILE, and utility logic is supplied by PA_FCST_GLOBAL, PA_PROJECTS_MAINT_UTILS, and PA_UTILS.

Key Columns

  • FORECAST_EXISTS_FLAG — constant 'Y', confirming the row originates from the forecast summary.
  • PROJECT_ID, PROJECT_NUMBER, PROJECT_NAME — standard project identifiers.
  • ORG.NAME — name of the carrying-out organization from HR_ALL_ORGANIZATION_UNITS_TL.
  • CUSTOMER_NAME, PROJECT_CURRENCY_CODE — customer and project currency context.
  • PERIOD_NAME, START_DATE — forecast period details from PA_BUDGET_LINES.
  • FND_PROFILE.VALUE('PA_FORECASTING_PERIOD_TYPE') — the period type profile value in effect.
  • VALUE — probability-adjusted amount determined by the DECODE, dependent on profile settings such as PA_FCST_GLOBAL.GETPROJFCSTSHOWAMOUNT and GETPROBABILITYPERFLAG.

Common Use Cases and Queries

The view is typically used to report forecasted revenue, cost, labor hours, margin, or margin percentage by project and period. Because the returned measure depends on profile configuration, queries are usually filtered by project or period and the value interpreted in the context of the active profile option.

  • Project-level forecast revenue: SELECT project_number, period_name, value FROM apps.pa_fcst_project_sum_v WHERE project_id = :p_project_id;
  • Organization forecast summary: SELECT name, project_number, SUM(value) FROM apps.pa_fcst_project_sum_v GROUP BY name, project_number;
  • Customer forecast: SELECT customer_name, period_name, value FROM apps.pa_fcst_project_sum_v WHERE customer_name = :p_customer;

Consumers should treat the VALUE column as profile-dependent and validate PA_FORECASTING_PERIOD_TYPE and the PA_FCST_GLOBAL flags before interpreting results.