Search Results pa_deliverable_progress_v




Overview
Explore in AI Chat

Overview

PA_DELIVERABLE_PROGRESS_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module, valid and shipped under both 12.1.1 and 12.2.2. It presents a denormalized, reporting-oriented projection of deliverable progress information: each row combines a project, its task hierarchy element, the associated deliverable project element, the latest percent-complete record, the corresponding progress rollup record, and the current status names and icons resolved from the Projects status tables. The view is intended for inquiry, reporting, and integration scenarios where progress against deliverables must be displayed without navigating the full normalized PA schema.

The view is of particular interest to implementers investigating the profile option "allow_collab_prog_entry" (Allow Collaborative Progress Entry). The view text computes a literal column PROG_ENTRY_REQ_FLAG (returned as 'N') and exposes related control attributes such as PERCENT_COMP_ENABLE_FLAG from PA_PROJ_PROGRESS_ATTR. These columns indicate whether percent-complete entry is enabled for the structure and whether a progress entry is required, which directly maps to the behavior governed by collaborative progress entry settings in Oracle Projects.

Underlying Base Objects

The view is defined over the following documented base objects:

Key Columns

Common Use Cases and Queries

The view is typically queried for deliverable status dashboards, integration extracts, and diagnostics around progress entry behavior. A representative query, filtered to a project and the enable flag column relevant to project-controlled progress entry, is shown below.

  • Deliverable progress listing for a project, showing task, deliverable, percent complete, and status:
SELECT p.name       project_name,
       t.task_name,
       t.del_name   deliverable,
       t.del_manager_name,
       t.completed_percentage,
       t.eff_rollup_percent_comp,
       t.progress_status_name,
       t.eff_rollup_status_name,
       t.scheduled_start_date,
       t.scheduled_finish_date
FROM   apps.pa_deliverable_progress_v t,
       apps.pa_projects_all p
WHERE  t.project_id = p.project_id
AND    t.project_id = :project_id
ORDER  BY t.task_name, t.del_name;
  • Identifying deliverables where progress entry is enabled or outdated, used when validating profile-driven collaboration settings:
SELECT project_id, task_name, del_name,
       percent_comp_enable_flag,
       prog_entry_req_flag,
       progress_outdated_flag
FROM   apps.pa_deliverable_progress_v
WHERE  percent_comp_enable_flag = 'Y'
AND    progress_outdated_flag  = 'Y';
  • Extracting published, current progress records for interface tables or data warehousing:
SELECT project_id, del_id, del_number, del_name,
       completed_percentage, published_flag, current_flag,
       last_update_date
FROM   apps.pa_deliverable_progress_v
WHERE  current_flag = 'Y';

Because the view joins several status aliases and rollup sources, queries should always constrain by PROJECT_ID or DEL_ID to avoid full scans, and callers should be aware that GET_NEXT_PROGRESS_CYCLE is invoked per row, which can add cost on large extracts.