Search Results pa_xc_progress_status




Overview
Explore in AI Chat

Overview

The APPS.PA_PROJ_PROGRESS_REPORTS_V view is a reporting and integration layer over Oracle Projects progress reporting data in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes progress report records for projects and tasks, joining each report to its lookup definition so that a descriptive meaning accompanies the stored status code. The view is owned by the APPS schema and is intended for read-only consumption by reports, concurrent programs, OBIEE extracts, and external integrations that must display project progress information without reproducing the lookup join logic.

The search term "pa_xc_progress_status" refers to the lookup type that drives the status values in this view. By performing the lookup join internally, PA_PROJ_PROGRESS_REPORTS_V removes the requirement for downstream consumers to query PA_LOOKUPS separately, producing self-describing result sets suitable for public consumption.

Underlying Base Objects

The view is defined over two documented objects: PA_PROJ_PROGRESS_REPORTS and PA_LOOKUPS. In the ETRM documentation, PA_PROJ_PROGRESS_REPORTS is referenced as a synonym and PA_LOOKUPS as a view. The defining query selects from PA_PROJ_PROGRESS_REPORTS PPR joined to PA_LOOKUPS PAL where PPR.PROGRESS_STATUS_CODE equals PAL.LOOKUP_CODE and PAL.LOOKUP_TYPE equals 'PA_XC_PROGRESS_STATUS'.

Because the join is an inner equijoin on the lookup table, a progress report row appears in the view only when a corresponding active lookup row exists for the PA_XC_PROGRESS_STATUS lookup type. The view is therefore a filtered, denormalized projection that layers lookup semantics onto the base progress report records. Total row counts cannot exceed the number of qualifying rows in PA_PROJ_PROGRESS_REPORTS.

Key Columns

Common Use Cases and Queries

Typical applications include project status dashboards, progress report listings for project managers, and extracts feeding enterprise reporting. The view is also useful when validating the active values of the PA_XC_PROGRESS_STATUS lookup as they appear in real report data.

  • List all progress reports for a project with readable status: SELECT progress_report_id, project_id, task_id, meaning, percent_complete FROM apps.pa_proj_progress_reports_v WHERE project_id = :p_project_id ORDER BY progress_asof_date DESC;
  • Summarize reports by status meaning: SELECT meaning, COUNT(*) FROM apps.pa_proj_progress_reports_v GROUP BY meaning;
  • Identify in-flight reports: SELECT progress_report_id, report_status, progress_asof_date FROM apps.pa_proj_progress_reports_v WHERE report_status = 'IN_PROGRESS';

Consumers should treat the view as read-only, avoid relying on column order, and remember that rows whose status codes lack a matching PA_XC_PROGRESS_STATUS lookup entry are excluded by the inner join.