Search Results pa_assignment_prog_hist_v




Overview
Explore in AI Chat

Overview

PA_ASSIGNMENT_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 presents summarized assignment-level progress history used by the Progress workbench and related project progress reporting. The view consolidates actual-to-date quantities, estimated-to-complete (ETC) values, and derived estimates-at-completion (EAC) for cost and effort at the assignment level, organized by resource class.

Because it drives progress rollup and EAC/ETC presentation, the view is queried by Progress Manager, Project Status Inquiry style reports, and custom progress dashboards. It returns data as of a specific reporting date (AS_OF_DATE) and supports baseline versus current comparisons through baseline assignment dates. In 12.2.2 the object is documented as VALID with the same definition as 12.1.1, allowing identical SQL to be used across both releases without modification.

Underlying Base Objects

The view is defined over the following documented base tables, synonyms, views, and packages:

Documented references explicitly include PTAV (PA_TASK_ASGMTS_V) and PPR (PA_PROGRESS_ROLLUP), from which the view DERIVES its DECODE-based columns.

Key Columns

Common Use Cases and Queries

The view supports progress analysis by resource class, baseline versus current variance, and cost/effort EAC reporting. A typical query filters by project and as-of date:

  • SELECT project, task, actual_cost, est_at_completion_cost, actual_effort, est_at_completion_effort FROM pa_assignment_prog_hist_v WHERE as_of_date = :as_of_date;
  • Join to PA_PROJECTS_ALL and PA_TASK_ASGMTS_V on project and assignment for descriptive columns and assignment-level baselines.
  • Compare BASELINED_ASGMT dates against ACTUAL/ESTIMATED dates for schedule slippage analysis.
  • Feed data to custom dashboards presenting baseline versus current cost and effort EAC at assignment level.

Users searching for pa_assignment_prog_hist_v typically need these assignment-level progress results for custom reporting, since the view already encapsulates the resource-class DECODE and the SUM_ETC_VALUES logic required for accurate EAC calculation.