Search Results progress_status_icon




Overview
Explore in AI Chat

Overview

APPS.PA_PROGRESS_REPORTS_MAIN_V is a reporting view in the Oracle E-Business Suite Projects (PA) module that consolidates progress report header information for project and task objects. Its primary role is to drive the Progress Reporting workbench and related inquiry pages, returning one row per report version plus synthetic placeholder rows for report types that have a page layout defined but no version yet created. The view is defined with a UNION of two branches, both filtered on Page_Type_Code = 'PPR', which identifies Progress Report pages.

The first branch selects actual progress report versions from PA_PROGRESS_REPORT_VERS. The second branch returns layout-only rows from PA_OBJECT_PAGE_LAYOUTS with NULL version attributes and Current_Flag = 'Y', representing a report type available for entry but not yet reported. For users investigating generation_method, the view is significant because the first branch carries an explicit predicate governing which versions are visible: rows are returned only when generation_method is NULL or equals 'MANUAL'. Auto-generated report versions are therefore excluded from this view.

Underlying Base Objects

The view is defined over the following documented objects:

  • PA_PROGRESS_REPORT_VERS (synonym) — the primary source of report version rows in the first UNION branch.
  • PA_OBJECT_PAGE_LAYOUTS (synonym) — joined to version rows on object_type, object_id, and report_type_id, and independently sourced in the second UNION branch.
  • PA_REPORT_TYPES (synonym) — supplies the report type name via RTyp.Name.
  • PA_PROJECT_STATUSES (synonym) — aliased twice (PPS1, PPS2) to resolve page status and progress status codes into names and icon indicators.
  • PA_PROGRESS_REPORT_UTILS (package) — called as Check_Security_For_ProgRep to compute the report_access column.
  • PA_RESOURCE_UTILS (package) — called as get_resource_name to resolve the reported-by resource name.

The join to PA_OBJECT_PAGE_LAYOUTS acts as a filter enforcing that a version is only surfaced when a corresponding page layout exists for the same object and report type.

Key Columns

  • Object_Type / Object_Id — the project or task to which the report belongs.
  • Page_Type_Code / Page_Id — page classification (always 'PPR') and page identifier.
  • Report_Type_Id / Name — the progress report type and its descriptive name.
  • Version_Id — version identifier; NULL for layout-only rows from the second branch.
  • Report_Status_Code and Page_Status_Meaning — report status resolved through PPS1.
  • Progress_Status_Code and Progress_Status_Meaning — progress status resolved through PPS2, with Status_icon_ind and Status_icon_active_ind controlling icon display.
  • Next_Reporting_Date — from PA_OBJECT_PAGE_LAYOUTS, indicating the scheduled next report date.
  • Report_Start_Date / Report_End_Date — the reporting period covered.
  • Reported_By / Reported_By_Name — resource identifier and name resolved via PA_RESOURCE_UTILS.
  • Current_Flag — 'Y' for the latest version or for layout-only placeholder rows.
  • Overview / Comments — narrative content entered on the report.
  • Published_Date / Canceled_Date — lifecycle timestamps.
  • Record_Version_Number — optimistic locking column.
  • report_access — security determination returned by Check_Security_For_ProgRep.

Common Use Cases and Queries

Typical uses include populating the progress report list of values, driving the workbench query form, and performing security-filtered inquiries for a given project. Because the view restricts to manual generation, it is not suitable for auditing auto-generated progress reports. A representative query follows:

  • SELECT report_type_id, name, version_id, report_status_code, progress_status_meaning, report_start_date, report_end_date, current_flag FROM apps.pa_progress_reports_main_v WHERE object_type = 'PA_PROJECTS' AND object_id = :project_id AND report_access = 'Y';
  • SELECT object_id, report_type_id, name, next_reporting_date FROM apps.pa_progress_reports_main_v WHERE current_flag = 'Y' AND version_id IS NULL; — retrieves report types awaiting a first manual report entry.

To surface auto-generated versions, query PA_PROGRESS_REPORT_VERS directly with a generation_method predicate rather than relying on this view.