Results for “progress_status_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PA_PROJ_CURR_STATUS_REP_V view is a reporting object in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema. It exposes the current published progress status report for project records. In the context of EBS 12.1.1 and 12.2.2, the view is classified as VALID and serves as a read-only reporting interface that consolidates progress reporting metadata across three PA entities into a single denormalized result set.

The view is intentionally narrow in scope. Its defining predicate filters to OBJECT_TYPE = 'PA_PROJECTS', PAGE_TYPE_CODE = 'PPR' (Project Progress Report), REPORT_STATUS_CODE = 'PROGRESS_REPORT_PUBLISHED', CURRENT_FLAG = 'Y', and REPORT_TYPE_ID = 1. As a result, it returns only the single current, published progress report of the default progress report type for each project. This makes the view suitable for status dashboards, project health reporting, and lightweight integrations that need the latest published narrative rather than the full historical reporting chain.

Underlying Base Objects

The view is defined over three synonym-referenced base objects:

• PA_PROGRESS_REPORT_VERS (PRV) — the driving table, supplying report versions, dates, overview and comments text, the progress status code, the published date, and the current flag.
• PA_PROJECT_STATUSES (PS) — joined on PRV.PROGRESS_STATUS_CODE = PS.PROJECT_STATUS_CODE with PS.STATUS_TYPE = 'PROGRESS', supplying the human-readable status name and icon attributes.
• PA_REPORT_TYPES (PRT) — joined on PRV.REPORT_TYPE_ID = PRT.REPORT_TYPE_ID, supplying the report type name.

The join structure is an inner-join model. If a progress report version lacks a matching progress-type status or report type row, it is excluded. Because the report type join is additionally constrained to REPORT_TYPE_ID = 1, only the standard progress report type is surfaced regardless of other configured report types.

Key Columns

• PROJECT_ID — identifier of the project to which the current published report belongs. Note the view text selects OBJECT_ID from the base table; it is exposed as the project key.
• REPORT_TYPE_ID / REPORT_TYPE_NAME — the report type key and its descriptive name from PA_REPORT_TYPES.
• PROGRESS_STATUS_CODE / PROGRESS_STATUS_NAME — the coded status and its translated display name from PA_PROJECT_STATUSES.
• STATUS_ICON_IND / STATUS_ICON_ACTIVE_IND — indicators controlling the status icon rendering and whether that icon is currently active.
• REPORT_START_DATE / REPORT_END_DATE — the reporting period the published progress report covers.
• PUBLISHED_DATE — the date the report version was published.
• OVERVIEW / COMMENTS — free-text narrative fields captured on the progress report version.

Common Use Cases and Queries

Typical uses include project status dashboards, exception reporting on reports not refreshed within a period, and integration extracts feeding downstream status systems. A basic retrieve of all current published progress reports:

SELECT project_id, report_type_name, progress_status_name, report_start_date, report_end_date, published_date FROM apps.pa_proj_curr_status_rep_v;

To inspect the narrative for a specific project:

SELECT project_id, progress_status_name, published_date, overview, comments FROM apps.pa_proj_curr_status_rep_v WHERE project_id = :p_project_id;

To identify stale published reports, filter on the published date, for example WHERE published_date < SYSDATE - 30. Because the view is filtered to CURRENT_FLAG = 'Y' and the published status, it never returns superseded versions; historical reporting must query PA_PROGRESS_REPORT_VERS directly. Queries should be issued against the APPS schema or a synonym, with appropriate Projects security applied by the calling application layer.