Search Results pa_progress_report_vers




Overview
Explore in AI Chat

Overview

PA_PROGRESS_REPORT_VERS is a Projects (PA) module table that stores header information for each version of a status or progress report associated with an object in Oracle EBS. It is a versioning table: rather than holding a single current record per report, it retains one row per report version, which supports audit history, draft-to-published workflows, and point-in-time retrieval of report content and status. In release 12.1.1 and 12.2.2, the table is owned by the PA schema and is documented as VALID in ETRM with 23 columns.

From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification. The table's unique index is on VERSION_ID, and it references VEA_VERSIONS via VERSION_ID, indicating the row sits alongside a shared versioning hub rather than acting as a purely independent hub. It also carries the descriptive and status attributes (report dates, status codes, narrative fields) typical of satellite data. This is a heuristic suggestion for modeling, not a declared design constraint of the EBS schema.

Key Information Stored

The unique index PA_PROGRESS_REPORT_VERS_U1 on VERSION_ID identifies the business-key candidate for a single report version. Key columns include:

Common Use Cases and Queries

Typical reporting scenarios include retrieving the latest published status report for a project, auditing the version history of a report, and reconciling report progress against project milestones. A common query pattern filters on the current version or the highest summary version per object:

  • Fetch the active version for an object: SELECT * FROM PA.PA_PROGRESS_REPORT_VERS WHERE OBJECT_ID = :object_id AND CURRENT_FLAG = 'Y';
  • List all versions in sequence: SELECT VERSION_ID, SUMMARY_VERSION_NUMBER, REPORT_STATUS_CODE, PUBLISHED_DATE FROM PA.PA_PROGRESS_REPORT_VERS WHERE OBJECT_ID = :object_id ORDER BY SUMMARY_VERSION_NUMBER DESC;
  • Join to report types: SELECT v.*, t.REPORT_TYPE FROM PA.PA_PROGRESS_REPORT_VERS v, PA.PA_REPORT_TYPES t WHERE v.REPORT_TYPE_ID = t.REPORT_TYPE_ID;
  • Filter by reporting period for status dashboards using REPORT_START_DATE and REPORT_END_DATE.

These patterns support project status reporting, executive dashboards, and audit extracts.

Related Objects

The most significant related objects, grounded in the documented foreign keys and versioning relationships, are:

  • PA_REPORT_TYPES — joined via REPORT_TYPE_ID; defines the report template/type.
  • VEA_VERSIONS — joined via VERSION_ID; the shared versioning entity underpinning this satellite.
  • PA_PROGRESS_REPORTS and related PA progress report detail tables — parent/context rows for page, section, and line content.
  • PA_PROJECTS_ALL / PA_TASKS — potential OBJECT_ID targets when OBJECT_TYPE denotes project or task.
  • PER_ALL_PEOPLE_F — resolves REPORTED_BY and audit user columns.

Together these relationships allow status report versions to be reconstructed, validated, and reported against in Oracle Projects.