Search Results y1_rightattribute1




Overview
Explore in AI Chat

Overview

APPS.PA_FCST_PROJ_HDR_V is a reporting view in Oracle Projects (Oracle E-Business Suite 12.1.1 and 12.2.2) that presents project-level forecasting data in a pre-formatted, display-ready structure. It is designed to feed the Project Forecast header region of the Oracle Projects forecasting UI and accompanying BI Publisher or Oracle Reports outputs, rather than to serve as a transactional or integration entity. The view consolidates forecast amounts and percentages from budget-versions flagged with the FORECASTING_BUDGET_TYPE code and layers on severity formatting and probability weighting driven by profile options.

Its role is presentation: it emits both numeric values (the value column) and locale-aware character strings (the y1_rightattribute1 and y1_leftattribute1 columns) so that downstream consumers can render forecast totals without additional formatting logic. The presence of y1_seq and x1_seq identifies this as a "pivot-style" view intended to feed cross-tab or matrix displays, where y1 forms the row dimension and x1 the column dimension.

Underlying Base Objects

The view is defined over the following documented base objects:

  • PA_PROJECTS_ALL (synonym) — supplies project_id and segment1 (aliased as y1).
  • PA_BUDGET_VERSIONS (synonym) — restricts rows to versions whose budget_type_code equals the FORECASTING_BUDGET_TYPE and whose current_ flag identifies the active version.
  • PA_BUDGET_LINES (synonym) — provides period-level revenue, burdened_cost, quantity, period_name, and start_date.
  • PA_RESOURCE_ASSIGNMENTS (synonym) — supplies total_plan_revenue, total_plan_burdened_cost, total_plan_quantity, and average_discount_percentage.
  • PA_FCST_GLOBAL (package) — its functions (GetProjFcstShowAmount, GetProbabilityPerFlag, GetProbabilityPer, GetProjFcstStartDate, GetProjFcstEndDate, GetProjectId) drive the display mode, probability weighting, and date filtering.
  • PA_FCST_PERIODS_TMP_V (view) and PA_PERIOD_PROCESS_PKG (package) — support period derivation and alignment.
  • FND_PROFILE (package) and DUAL (synonym) — support profile lookups and the inline single-row filter subquery.

The ratio of profile- and package-driven logic to plain column selection is high, so row counts and values shift with the current user's profile settings.

Key Columns

  • project_id / y1 — Project identifier and its segment1 value, the row grouping key.
  • y1_seq / x1_seq — Sequence numbers used for grouping and ordering in matrix output; x1_seq is generated by DENSE_RANK() OVER (PARTITION BY y1 ORDER BY period_start_date).
  • y1_rightattribute1 — Right-aligned formatted forecast total, computed from resource-assignment totals selected by the display mode and multiplied by the probability factor, formatted via the mask '999,999,999,999,990.99'.
  • y1_leftattribute1 — Formatted average discount percentage, mask '999,999,990.99'.
  • x1 — Period name used as the column dimension.
  • value — Period-level numeric forecast value for the selected display mode (revenue, cost, labor hours, margin, or margin percentage).
  • period_start_date — Period start date, used for ordering.

Common Use Cases and Queries

The primary scenarios are forecast header reporting, cross-tab/matrix displays, and diagnostic inspection of formatted values. Because the view filters internally on the current forecast configuration, consumers should not re-filter on budget version in most cases.

Typical query pattern:

SELECT y1, y1_rightattribute1, y1_leftattribute1, value
  FROM apps.pa_fcst_proj_hdr_v
 WHERE project_id = :p_project_id
 ORDER BY y1, x1_seq;

A matrix-oriented query relies on the sequence columns:

SELECT y1,
       y1,
       x1_seq,
       value,
       y1_rightattribute1
  FROM apps.pa_fcst_proj_hdr_v
 WHERE y1 = :p_project_number;

A diagnostic query inspects formatted output alongside the raw numeric value to detect rounding or probability-weighting differences.

  • Verify that the input project has an active forecasting budget version, or the view returns no rows.
  • Set the relevant PA forecast profile options before running, because GetProjFcstShowAmount and GetProbabilityPerFlag alter both y1_rightattribute1 and value.
  • Join to PA_PROJECTS_ALL when project name or number is required, since the view exposes only y1 for identification.