Search Results pa_fcst_project_hdr_v




Overview
Explore in AI Chat

Overview

PA_FCST_PROJECT_HDR_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Projects (PA) product family. It is documented as a VALID object in both Release 12.1.1 and 12.2.2. The view presents summarized project forecasting information at the project currency level, aggregating cost, revenue, quantity (hours), margin, and margin percentage for forecast data associated with projects.

In practical terms, the view acts as a header-level forecast summary: rather than exposing individual forecast budget lines, it rolls those lines up by the project's currency code and applies probability weighting through the PA_FCST_GLOBAL package. This makes it suitable for reporting layers, concurrent program output, and integration points where a compact, currency-grouped forecast total is required rather than line-level detail.

Underlying Base Objects

The view is defined over the following documented base objects:

The grouping is performed on PR.PROJECT_CURRENCY_CODE, so all forecast lines sharing a currency are consolidated into a single result row. Aggregation is applied to the probability-adjusted values, and all numeric results are converted to character strings using the format mask '999, 999, 999, 999, 990.99' (or '999, 999, 990.99' for the margin percentage).

Key Columns

  • CURRENCY_CODE — the project currency code from PA_FCST_PROJECT_LIST_V, used as the grouping key.
  • COST — the sum of BURDENED_COST across forecast lines, adjusted for probability where applicable, formatted as a string.
  • REVENUE — the sum of REVENUE across forecast lines, similarly probability-adjusted and formatted.
  • HOURS — the sum of QUANTITY, representing forecast effort in the forecast's unit of measure.
  • MARGIN — the sum of (REVENUE − BURDENED_COST), probability-adjusted.
  • MARGIN_PERCENTAGE — margin divided by revenue, multiplied by 100 and by the average probability factor; returns NULL when total revenue is zero.

Probability weighting is controlled by PA_FCST_GLOBAL.GETPROBABILITYPERFLAG. When the flag is 'N', no weighting is applied. Otherwise, the project's PROBABILITY_PERCENTAGE is divided by 100, with the value 1 (or null) treated as no adjustment.

Common Use Cases and Queries

Typical scenarios include forecast portfolio summaries, currency-level revenue and margin reporting, and feeding downstream dashboards or interfaces that require pre-aggregated forecast figures.

  • Retrieving all currency-level forecast totals for a period range.
  • Comparing forecast cost, revenue, and margin by currency.
  • Extracting margin percentages for profitability review.

A representative query is:

SELECT currency_code, cost, revenue, hours, margin, margin_percentage
FROM apps.pa_fcst_project_hdr_v;

Because the view aggregates without a project identifier in its select list, consumers should treat each row as a currency-level roll-up rather than project-specific data. Note also that all amount columns are returned as formatted character strings, so numeric comparisons or arithmetic in downstream queries require an explicit conversion.