Results for “pa_org_fcst_elements”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_ORG_FCST_ELEMENTS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores denormalized header information for Organization Forecasts. It functions as the master header record for forecast elements generated within the organization forecasting framework, holding the project, task, organization, budget version, and assignment context under which forecast lines are captured. Each row represents a single forecast element, identified by a surrogate primary key and linked to subordinate forecast line detail.

In Data Vault modeling terms, the FK topology suggests a satellite-leaning classification. The table carries a single-column surrogate primary key (FORECAST_ELEMENT_ID) plus a dense set of descriptive and foreign-key attributes rather than acting as a pure many-to-many join hub. Modelers may therefore treat it as a satellite attached to the underlying business keys (project, task, organization, budget version) that it references, although its role as a parent of PA_ORG_FORECAST_LINES also gives it a link-like header function.

Key Information Stored

The table comprises 18 documented columns. The most significant are:

• FORECAST_ELEMENT_ID — surrogate primary key (PA_ORG_FCST_ELEMENTS_PK) and the value propagated to child forecast lines; also enforced by unique index PA_ORG_FCST_ELEMENTS_U1.
• RECORD_VERSION_NUMBER — optimistic locking / record versioning indicator.
• ORGANIZATION_ID — forecasting organization, referencing HR_ALL_ORGANIZATION_UNITS.
• ORG_ID — operating unit context, referencing PA_IMPLEMENTATIONS_ALL.
• OTHER_ORGANIZATION_ID / OTHER_ORG_ID — counterparty organization and its operating unit, supporting provider/receiver relationships.
• BUDGET_VERSION_ID — the budget or forecast version against which the element is defined, referencing PA_BUDGET_VERSIONS.
• PROJECT_ID — owning project (PA_PROJECTS_ALL).
• TASK_ID — project task (PA_TASKS).
• TXN_PROJECT_ID — transaction project association (PA_PROJECTS_ALL).
• ASSIGNMENT_ID — project assignment context (PA_PROJECT_ASSIGNMENTS).
• RESOURCE_ID — resource associated with the forecast element.
• PROVIDER_RECEIVER_CODE — indicates the direction of the organizational forecast relationship.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.

Only FORECAST_ELEMENT_ID is documented as a unique business-key candidate; the remaining columns are descriptive or referential.

Common Use Cases and Queries

Typical scenarios include reporting organizational forecast headers, reconciling forecast elements to their lines, and tracing forecast context back to project, task, and budget version. A representative query joins the header to its child lines:

• SELECT e.forecast_element_id, e.project_id, e.task_id, e.organization_id, e.budget_version_id, l.forecast_line_id FROM pa_org_fcst_elements e, pa_org_forecast_lines l WHERE e.forecast_element_id = l.forecast_element_id;
• Filter by operating unit and project: ... WHERE e.org_id = :p_org_id AND e.project_id = :p_project_id.
• Resolve organization names via HR_ALL_ORGANIZATION_UNITS on ORGANIZATION_ID and via PA_PROJECTS_ALL on PROJECT_ID for descriptive reporting.
• Period-denormalized reporting joins PA_PROJ_PERIODS_DENORM on OBJECT_ID = FORECAST_ELEMENT_ID.

Related Objects

The following objects are most significant by documented foreign-key relationship:

• PA_ORG_FORECAST_LINES — child detail table; joined on FORECAST_ELEMENT_ID.
• PA_PROJ_PERIODS_DENORM — denormalized period records referencing OBJECT_ID = FORECAST_ELEMENT_ID.
• HR_ALL_ORGANIZATION_UNITS — referenced via ORGANIZATION_ID and OTHER_ORGANIZATION_ID.
• PA_PROJECTS_ALL — referenced via PROJECT_ID and TXN_PROJECT_ID.
• PA_TASKS — referenced via TASK_ID.
• PA_BUDGET_VERSIONS — referenced via BUDGET_VERSION_ID.
• PA_PROJECT_ASSIGNMENTS — referenced via ASSIGNMENT_ID.
• PA_IMPLEMENTATIONS_ALL — referenced via ORG_ID and OTHER_ORG_ID.

These relationships position PA_ORG_FCST_ELEMENTS as the central header object of the organization forecast sub-model within Oracle Projects.