Search Results progress_overview




Overview
Explore in AI Chat

Overview

APPS.PA_CURR_PROJ_TASK_PROG_V is a reporting view in the Oracle E-Business Suite Projects (PA) module that consolidates current project and task progress information, including physical percent complete data. It is registered as an internal Oracle Applications object with FND Design Data PA.PA_CURR_PROJ_TASK_PROG_V and is documented as VALID in Oracle ETRM for release 12.2.2 (and applicable to 12.1.1). The view presents one row per project, task, and percent-complete entry, together with the associated progress status, dates, effort quantities, and publication attributes. Because it exposes the PERCENT_COMPLETE_ID column, it is frequently encountered when developers or analysts search for that identifier, which is the primary key of the underlying PA_PERCENT_COMPLETES table. As with other internal PA views, Oracle classifies this object as Oracle Internal Use Only; access is intended through standard Oracle Applications programs rather than direct SQL.

Underlying Base Objects

The documented base objects referenced by this view are:

  • PA_PERCENT_COMPLETES (synonym) — the primary source of percent-complete transactions, supplying PERCENT_COMPLETE_ID, PROJECT_ID, TASK_ID, and the associated progress dates, percentages, and effort quantities.
  • PA_PROGRESS_ROLLUP (synonym) — supports the rollup of progress and effort metrics used for summarized or cumulative values.
  • PA_PROJECT_STATUSES (synonym) — supplies the progress status code and name used to classify the state of the progress entry.
  • HZ_PARTIES (synonym) — resolves the publishing party identity, populating PUBLISHED_BY_NAME from the party record identified by PUBLISHED_BY_PARTY_ID.

The view therefore functions principally as a denormalized projection of PA_PERCENT_COMPLETES enriched with status and party descriptions, rather than as an independent data store.

Key Columns

Common Use Cases and Queries

Typical scenarios include retrieving the current published progress for a project or task, reconciling percent-complete entries against project statuses, and auditing who published a given progress record. A basic lookup by progress identifier:

SELECT project_id, task_id, percent_complete_id, as_of_date, completed_percentage
FROM apps.pa_curr_proj_task_prog_v
WHERE percent_complete_id = :p_percent_complete_id;

Listing the current progress entries for a project:

SELECT task_id, progress_status_name, completed_percentage, cumulative_work_qty
FROM apps.pa_curr_proj_task_prog_v
WHERE project_id = :p_project_id
AND current_flag = 'Y'
ORDER BY task_id, as_of_date;

Because the view is flagged Oracle Internal Use Only, these queries should be used for diagnostic or reporting purposes consistent with Oracle support policy.