Search Results pa_percent_completes

Overview

The PA_PERCENT_COMPLETES table is a core transactional table within Oracle E-Business Suite's Projects (PA) module, specifically in versions 12.1.1 and 12.2.2. It serves as the central repository for storing estimated percent completion data across all levels of a project's work breakdown structure (WBS). This table is fundamental to project performance measurement and earned value management, enabling project managers to track progress against baselines. The data stored here feeds into project status reporting, financial recognition calculations, and performance analysis, forming a critical link between project execution data and financial outcomes.

Key Information Stored

The table's primary key uniquely identifies a percent completion record by the combination of TASK_ID and DATE_COMPUTED, indicating that multiple historical completion estimates can be stored for a single task. Based on the provided metadata, essential columns and their purposes include: TASK_ID, which links to the PA_TASKS table to identify the specific work package; PROJECT_ID, linking to PA_PROJECTS_ALL; and DATE_COMPUTED, which timestamps the estimate. The OBJECT_ID and OBJECT_VERSION_ID columns link to the project element hierarchy (PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS), allowing percent completion to be tracked for various WBS element types. Status is managed via STATUS_CODE and PROGRESS_STATUS_CODE, linked to PA_PROJECT_STATUSES. The PUBLISHED_BY_PARTY_ID column, linked to HZ_PARTIES, tracks the external party responsible for publishing the completion estimate, which is crucial for contractor reporting.

Common Use Cases and Queries

This table is primarily accessed for project progress reporting and audit trails. A common use case is generating a current percent complete report for a project or a set of tasks. Another critical scenario involves analyzing progress trends over time by querying historical DATE_COMPUTED entries for a task. Sample SQL to retrieve the latest percent complete for all tasks in a specific project might involve a subquery or analytic function to find the most recent DATE_COMPUTED per TASK_ID. Data from this table is also integral to calculating earned value metrics like Schedule Performance Index (SPI) and Cost Performance Index (CPI) when joined with cost and budget tables. Implementation-specific custom reports for project dashboards frequently source their progress data from PA_PERCENT_COMPLETES.

Related Objects

As indicated by its foreign key constraints, PA_PERCENT_COMPLETES has strong dependencies on several key Projects tables. Its primary relationship is with PA_TASKS. It also maintains fundamental links to the project master (PA_PROJECTS_ALL) and the work breakdown structure hierarchy through PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS. Status code validation is performed via PA_PROJECT_STATUSES. The link to HZ_PARTIES (via PUBLISHED_BY_PARTY_ID) integrates with Oracle Trading Community Architecture for third-party data. In practice, this table is often accessed indirectly through standard Oracle Projects APIs or views, which ensure business logic and security rules are applied when reading or writing percent completion data.