Search Results pa_proj_task_prog_hist_v




Overview
Explore in AI Chat

Overview

PA_PROJ_TASK_PROG_HIST_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes project and task progress history by combining project definitions, workplan element versions, percent-complete records, and rolled-up progress attributes into a single reporting structure. The view is primarily used for progress reporting, project status dashboards, and integration extracts where historical and current progress values for tasks and structures must be presented together.

Because it draws from versioned project elements and progress rollup tables, the view is well suited to queries that require the latest computed percentage complete, scheduled and actual dates, and the effective rolled-up percent complete across the work breakdown structure. It also surfaces lookup meanings for work quantity items and units, making it useful for out-of-the-box reporting without additional joins to lookup tables.

Underlying Base Objects

The view is defined over the following documented objects:

The view joins these objects to produce a denormalized projection of element-level progress, keyed primarily by PROJECT_ID, PROJ_ELEMENT_ID, and ELEMENT_VERSION_ID.

Key Columns

Regarding the searched term, effort_enabled_flag is not a column exposed by this view; effort-related information is instead represented through PLANNED_EFFORT and ESTIMATED_REMAINING_EFFORT.

Common Use Cases and Queries

Typical uses include project progress dashboards, task-level percent-complete reports, and extracts for status reporting. A basic query returns current progress for a project:

  • SELECT PROJECT_ID, NAME, PROJ_ELEMENT_ID, WBS_NUMBER, WBS_LEVEL, COMPLETED_PERCENTAGE, EFF_ROLLUP_PERCENT_COMP FROM PA_PROJ_TASK_PROG_HIST_V WHERE PROJECT_ID = :project_id;
  • SELECT WBS_NUMBER, PLANNED_EFFORT, SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE, MILESTONE_FLAG FROM PA_PROJ_TASK_PROG_HIST_V WHERE PROJECT_ID = :project_id AND OBJECT_TYPE = 'PA_TASKS';
  • SELECT PROJ_ELEMENT_ID, ACTUAL_START_DATE, ACTUAL_FINISH_DATE, ESTIMATED_REMAINING_EFFORT FROM PA_PROJ_TASK_PROG_HIST_V WHERE CURRENT_FLAG = 'Y';

Because the view consolidates versioned and rolled-up progress data, it is preferable to query it directly rather than reconstructing the underlying joins, provided the reporting requirement matches the columns exposed.