Search Results progress_system_status_code




Overview
Explore in AI Chat

Overview

The APPS.PA_DELIV_ONLY_PROG_HIST_V view is a Projects (PA) module reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents the progress history of deliverables — the project elements classified as deliverables — alongside their associated percent-complete records, progress rollup data, scheduling information, and status attributes. The view consolidates deliverable identity, ownership, schedule, and progress metrics into a single flattened structure, which makes it suitable for progress reporting, integration extracts, and analytical queries without requiring callers to join multiple PA base tables individually.

The name reflects its scope: "DELIV_ONLY" indicates that it restricts output to deliverable-type project elements, "PROG" indicates progress and percent-complete content, and "HIST" indicates that historical percent-complete and rollup rows are retained rather than only the current record. Records are controlled by flags such as CURRENT_FLAG, PUBLISHED_FLAG, and RECORD_VERSION_NUMBER, which allow consumers to filter current versus historical rows.

Underlying Base Objects

The view is defined over the following documented base objects, all accessed through APPS synonyms:

  • PA_PROJECTS_ALL — supplies project header context (PROJECT_ID, NAME, SEGMENT1, LONG_NAME).
  • PA_PROJ_ELEMENTS (aliased DELPPE) — supplies the deliverable element identity, number, manager, and status.
  • PA_PROJ_ELEMENT_VERSIONS (aliased DELPPEV) — supplies the element version identifier for the deliverable.
  • PA_PROJ_ELEM_VER_SCHEDULE (aliased PPVSCH) — supplies scheduled start and finish dates for the deliverable version.
  • PA_PERCENT_COMPLETES (aliased PPC) — supplies percent-complete records, published-by party, comments, and current/published flags.
  • PA_PROGRESS_ROLLUP (aliased PPR) — supplies rolled-up progress, actual dates, and base percent complete.
  • PA_PROJECT_STATUSES (aliased PPS and its variants) — supplies decoded status names and icon indicators for progress, base progress, and effective rollup status.
  • PER_ALL_PEOPLE_F (aliased PAPF) — supplies the deliverable manager's full name.

Key Columns

Common Use Cases and Queries

Typical uses include deliverable progress dashboards, manager-level progress reporting, and extract programs requiring deliverable and percent-complete history in one pass.

SELECT project_id, name, del_name, del_number,
       del_manager_name, del_status_name,
       completed_percentage, scheduled_finish_date
FROM   apps.pa_deliv_only_prog_hist_v
WHERE  current_flag = 'Y'
AND    project_id = :p_project_id;

SELECT del_manager_name,
       COUNT(DISTINCT project_id)  project_count,
       AVG(completed_percentage)   avg_pct_complete
FROM   apps.pa_deliv_only_prog_hist_v
WHERE  current_flag = 'Y'
GROUP  BY del_manager_name
ORDER  BY project_count DESC;

Because the view exposes historical percent-complete and rollup rows, queries should generally filter on CURRENT_FLAG or restrict by LAST_UPDATE_DATE to avoid double counting. Reference to PUBLISHED_FLAG is appropriate when only formally published progress is relevant.