Results for “pa_top_task_fc_results_v”

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

Overview

PA_TOP_TASK_FC_RESULTS_V is an Oracle EBS Projects (PA) application view owned by the APPS schema. It presents summarized forecast results at the top task level, aggregating budget, actual, and encumbrance amounts from the project balances view. The view groups balances by budget version, project, top task, and date range, producing one consolidated row per combination. Its name, incorporating "FC" (forecast) and "TOP_TASK," signals its purpose: to supply top-task-level forecast figures for reporting and downstream processing within Oracle Projects. The object holds a VALID status in the ETRM registry for releases 12.1.1 and 12.2.2.

Underlying Base Objects

The documented base objects referenced by this view are PA_PROJECT_BAL_V (VIEW) and PA_BUDGETARY_CONTROLS_PKG (PACKAGE). The SELECT statement draws its data exclusively from PA_PROJECT_BAL_V, which is the project balances view supplying budget, actual, and encumbrance figures across projects. The view text identifies five key grouping columns—BUDGET_VERSION_ID, PROJECT_ID, TOP_TASK_ID, START_DATE, and END_DATE—while summing the BUDGET, ACTUALS, and ENCUMBRANCES measures. PA_BUDGETARY_CONTROLS_PKG is the budgetary controls package associated with the forecast and funds-checking logic; it appears among the referenced objects, reflecting the functional dependency of forecast results on budgetary control processing rather than a direct FROM-clause reference in the stored view text.

Key Columns

• PROJECT_ID — Identifier of the project to which the summarized forecast belongs.
• TOP_TASK_ID — Identifier of the top-level task, the aggregation point for the summarized amounts.
• BUDGET_VERSION_ID — The budget version against which balances are consolidated.
• START_DATE / END_DATE — The date range associated with the summarized forecast period.
• BUDGET — Summed budget amount for the project, top task, version, and period.
• ACTUALS — Summed actual cost amount, typically derived from expenditure items and cost distributions.
• ENCUMBRANCES — Summed encumbrance amount representing committed but unspent funds.

Collectively these columns allow comparison of planned, committed, and consumed amounts at a single top-task granularity.

Common Use Cases and Queries

The view is typically used for top-task-level forecast reporting, budget-versus-actual-versus-encumbrance analysis, and reconciliation of forecast results within budgetary control workflows. A basic query retrieves summarized results for a given project and budget version:

SELECT project_id, top_task_id, budget_version_id, start_date, end_date, budget, actuals, encumbrances FROM apps.pa_top_task_fc_results_v WHERE project_id = :project_id AND budget_version_id = :budget_version_id;

For variance analysis, a derived query computes remaining funds:

SELECT project_id, top_task_id, budget, actuals, encumbrances, (budget - actuals - encumbrances) AS remaining FROM apps.pa_top_task_fc_results_v WHERE project_id = :project_id;

Because the view performs GROUP BY aggregation, additional joins to PA_PROJECTS_ALL and PA_TASKS for descriptive attributes are common in reporting solutions. The view inherits security and data visibility from PA_PROJECT_BAL_V; consumers should apply appropriate project security and operate within the PA reporting context to obtain accurate forecasts.