Search Results pa_task_prog_hist_v




Overview
Explore in AI Chat

Overview

The PA_TASK_PROG_HIST_V view is a Projects (PA) module reporting object owned by the APPS schema in Oracle E-Business Suite. It presents a consolidated, denormalized picture of task-level and workplan-level progress for projects, combining published percentage-complete records with rollup progress quantities, element structure attributes, and project status information. The view is defined with a "history" orientation: rather than showing only the current state of a task, it exposes the computed percentage-complete rows that have been published by a responsible party, together with the as-of date of the computation. This makes it suitable for progress trend reporting, status dashboards, and integration extracts that must reproduce the progression of a task over time.

Because the view joins published structures, percent-complete records, and progress rollup rows, it functions as a single-query source for task progress analytics without requiring consumers to reconstruct the PA progress data model themselves. All version-qualified element data flows from PA_LATEST_PUB_STRUC_TASKS_V, ensuring only the latest published structure versions are surfaced.

Underlying Base Objects

ETRM documents the following referenced objects for this view:

  • PA_LATEST_PUB_STRUC_TASKS_V (view) — supplies published workplan task and element attributes; filtered to STRUCTURE_TYPE_CLASS_CODE='WORKPLAN'.
  • PA_PERCENT_COMPLETES (synonym) — the published percentage-complete and progress comment records, including the publishing party and status code.
  • PA_PROGRESS_ROLLUP (synonym) — rolled-up progress metrics such as actual, estimated, cumulative, and incremental work quantities and effective rollup percent complete.
  • PA_PROJECT_STATUSES (synonym) — project status code, name, and status icon indicators, joined on the progress status code.
  • HZ_PARTIES (synonym) — resolves the publishing party identifier to a party name.
  • FND_GLOBAL (package) and PA_PROJ_ELEMENTS_UTILS (package) — referenced for session context and element utility logic within the view definition.

Joins to PA_PERCENT_COMPLETES, PA_PROGRESS_ROLLUP, HZ_PARTIES, and PA_PROJECT_STATUSES are predominantly outer joins, meaning workplan tasks without published progress are still represented with null progress attributes.

Key Columns

Common Use Cases and Queries

Typical uses include task progress dashboards, historical completion trending, and extract feeds for project reporting. A straightforward query retrieves published progress for a project:

SELECT project_number, task_number, task_name,
       as_of_date, completed_percentage,
       cumulative_work_quantity, party_name
  FROM apps.pa_task_prog_hist_v
 WHERE project_number = :p_project_number
 ORDER BY task_number, as_of_date;

To trend completion over time for a single task, filter on the element identifier and order by the as-of date. To report only current published records, add AND current_flag = 'Y' and AND published_flag = 'Y'. Because the view already restricts to WORKPLAN structures and published rows, consumers need not re-apply those predicates, though restricting by project_id is recommended for performance.