Search Results base_percent_complete




Overview
Explore in AI Chat

Overview

PA_PROGRESS_ROLLUP is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores rolled-up progress information for project tasks and reporting structures. It aggregates percent complete, effort, cost, and earned value data across the project hierarchy, supporting progress reporting, earned value management, and the Project Status Inquiry (PSI) functionality. Physical schema consists of 125 columns owned by the PA schema.

From a Data Vault modeling perspective, the metadata classifies this object as a link. This heuristic reflects the table's role as a transactional/associative structure connecting projects, tasks, and structures across periodic snapshots.

Key structural attributes include the surrogate primary key PROGRESS_ROLLUP_ID (indexed by PA_PROGRESS_ROLLUP_PK and unique index PA_PROGRESS_ROLLUP_U1), and a business-key candidate PA_PROGRESS_ROLLUP_U2 spanning PROJECT_ID, OBJECT_ID, OBJECT_TYPE, STRUCTURE_TYPE, AS_OF_DATE, PROJ_ELEMENT_ID, CURRENT_FLAG, STRUCTURE_VERSION_ID, and CBS_ELEMENT_ID.

Key Information Stored

Common Use Cases and Queries

Progress reporting and earned value analysis are the principal use cases. The CURRENT_FLAG and AS_OF_DATE columns allow point-in-time retrieval of the latest rolled-up metrics.

Example — retrieve current rolled-up progress for a project:

SELECT pr.PROJECT_ID, pr.OBJECT_ID, pr.EFF_ROLLUP_PERCENT_COMP, pr.EARNED_VALUE, pr.AS_OF_DATE FROM PA.PA_PROGRESS_ROLLUP pr WHERE pr.PROJECT_ID = :project_id AND pr.CURRENT_FLAG = 'Y';

Example — join to project master to enrich reporting:

SELECT p.SEGMENT1, pr.EFF_ROLLUP_PERCENT_COMP, pr.PPL_ACT_COST_TO_DATE_PC FROM PA.PA_PROGRESS_ROLLUP pr, PA.PA_PROJECTS_ALL p WHERE pr.PROJECT_ID = p.PROJECT_ID AND pr.CURRENT_FLAG = 'Y' AND pr.STRUCTURE_TYPE = 'TASK';

Related Objects

  • PA_PROJECTS_ALL — joined on PROJECT_ID; the master project record.
  • PA_PROJ_ELEMENTS — joined on OBJECT_ID and PROJ_ELEMENT_ID.
  • PA_PROJ_ELEMENT_VERSIONS — joined on OBJECT_VERSION_ID and STRUCTURE_VERSION_ID.
  • PA_PROJECT_STATUSES — joined on PROGRESS_STATUS_CODE.
  • FND_CURRENCIES — joined on TXN_CURRENCY_CODE.
  • GL_DAILY_CONVERSION_TYPES — referenced by PROJFUNC_COST_RATE_TYPE and PROJ_COST_RATE_TYPE.
  • PA_STRUCTURES_TASKS_TMP — references this table via PROGRESS_ROLLUP_ID, indicating use during structure rollup processing.