Search Results base_progress_status_code




Overview
Explore in AI Chat

Overview

The PA_DELIVERABLE_PROG_HIST_V view in the APPS schema is a Projects (PA) module reporting object that consolidates the progress and completion history of deliverables and structure/task elements within a project. It is a denormalized, read-only view purpose-built to answer the recurring business question: "What is the progress status of this deliverable or task, and what percentage complete has been reported against it?" The view joins project header information, project element (task or structure) definitions, element version schedules, percent-complete publication records, and progress rollup records into a single flattened result set.

Its primary role is in Oracle EBS reporting and integration layers — Oracle Projects dashboards, BI Publisher reports, and outbound interfaces that need to expose deliverable progress without traversing the underlying normalized tables directly. Because it exposes both the element-level percent complete record (PA_PERCENT_COMPLETES) and the rolled-up progress (PA_PROGRESS_ROLLUP), it supports reconciliation between what a task owner published and what the system computed as the effective rollup.

Underlying Base Objects

The view is defined over several PA base tables and synonyms. The principal objects and their contribution are:

Key Columns

Common Use Cases and Queries

Typical scenarios include deliverable status reporting, progress reconciliation between reported and rolled-up percentages, and feeding project progress into downstream analytics. Because BASE_PROGRESS_STATUS_NAME is returned as a literal NULL, users requiring the descriptive name must join PA_PROJECT_STATUSES on BASE_PROGRESS_STATUS_CODE.

SELECT project_id,
       name,
       del_number,
       del_name,
       completed_percentage,
       base_percent_complete,
       base_progress_status_code
FROM   apps.pa_deliverable_prog_hist_v
WHERE  current_flag = 'Y'
AND    published_flag = 'Y';

To attach a description to the base progress status code, join the status table:

SELECT v.name,
       v.del_name,
       v.base_progress_status_code,
       s.project_status_name base_status_name
FROM   apps.pa_deliverable_prog_hist_v v,
       apps.pa_project_statuses s
WHERE  v.base_progress_status_code = s.project_status_code;

Note that the view carries no application-defined WHERE clause guarantees beyond those in its definition; callers should filter on CURRENT_FLAG or PUBLISHED_FLAG to avoid retrieving superseded percent-complete history rows.