Results for “pa_percent_completes”

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

Overview

PA_PERCENT_COMPLETES is a Projects (PA) module table owned by the PA schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the estimated percent completion for all levels of the work breakdown structure (WBS), providing a historical and current record of physical progress captured against tasks on a project. The table is central to progress-based revenue recognition, effort reporting, and project performance analysis, since Oracle Projects relies on its rows to derive percent-complete-driven accruals, billing, and reporting figures.

Because the table records percent completion over time, it functions as a time-stamped transactional store rather than a static reference. Its columns capture estimating dates, completion percentages, estimated and actual date ranges, publishing metadata, and descriptive attributes.

Applying the heuristic Data Vault classification mined from the foreign-key structure, PA_PERCENT_COMPLETES is best modeled as a link table. It associates multiple business entities — tasks, projects, project elements, project element versions, statuses, and parties — while its composite key (TASK_ID, DATE_COMPUTED) and unique surrogate PERCENT_COMPLETE_ID support satellite-style history attributes such as COMPLETED_PERCENTAGE and CURRENT_FLAG.

Key Information Stored

The table contains 45 documented columns. The most significant for integration and reporting are:

• PROJECT_ID — the project to which the percent-complete record belongs (FK to PA_PROJECTS_ALL).
• TASK_ID — the WBS task being measured (FK to PA_TASKS). Part of the composite primary key.
• DATE_COMPUTED — the date the percent completion was calculated. Part of the composite primary key.
• COMPLETED_PERCENTAGE — the estimated percent complete value for the task at that point in time.
• PERCENT_COMPLETE_ID — the unique surrogate key defined by the unique index PA_PERCENT_COMPLETES_U1, a documented business-key candidate.
• CURRENT_FLAG — indicates whether the row is the current (most recent) percent-complete record for the task.
• OBJECT_ID / OBJECT_VERSION_ID — references to the project element (PA_PROJ_ELEMENTS) and element version (PA_PROJ_ELEMENT_VERSIONS) that the record applies to.
• OBJECT_TYPE — identifies the structure level of the record within the WBS.
• STRUCTURE_TYPE — the structure type associated with the record.
• STATUS_CODE / PROGRESS_STATUS_CODE — status and progress status codes referencing PA_PROJECT_STATUSES.
• PUBLISHED_FLAG / PUBLISHED_BY_PARTY_ID — indicate whether and by which party the percent-complete value was published (FK to HZ_PARTIES).
• CBS_ELEMENT_ID — links the record to a cost breakdown structure element.
• ESTIMATED_START_DATE / ESTIMATED_FINISH_DATE / ACTUAL_START_DATE / ACTUAL_FINISH_DATE — date ranges associated with the progress estimate.
• PROGRESS_COMMENT and DESCRIPTION — descriptive commentary on the progress entry.
• RECORD_VERSION_NUMBER and HISTORY_FLAG — support versioning and historical retention semantics.

Common Use Cases and Queries

Typical scenarios include retrieving the current percent complete per task, reconciling historical progress entries, and feeding progress-based reporting or revenue workflows. A representative query is:

• Current percent complete per task:
  SELECT ppc.PROJECT_ID, ppc.TASK_ID, ppc.COMPLETED_PERCENTAGE, ppc.DATE_COMPUTED
FROM PA.PA_PERCENT_COMPLETES ppc
WHERE ppc.CURRENT_FLAG = 'Y' AND ppc.TASK_ID = :task_id;
• History for a project:
  SELECT ppc.TASK_ID, ppc.COMPLETED_PERCENTAGE, ppc.DATE_COMPUTED, ppc.STATUS_CODE
FROM PA.PA_PERCENT_COMPLETES ppc
WHERE ppc.PROJECT_ID = :project_id
ORDER BY ppc.TASK_ID, ppc.DATE_COMPUTED DESC;
• Joining to tasks for WBS context:
  SELECT t.TASK_NUMBER, ppc.COMPLETED_PERCENTAGE
FROM PA.PA_PERCENT_COMPLETES ppc JOIN PA.PA_TASKS t ON t.TASK_ID = ppc.TASK_ID
WHERE ppc.CURRENT_FLAG = 'Y';

Reporting often filters on PUBLISHED_FLAG or STATUS_CODE to isolate validated progress, and correlates DATE_COMPUTED with accounting periods for period-end analysis.

Related Objects

• PA_TASKS — joined on PA_PERCENT_COMPLETES.TASK_ID = PA_TASKS.TASK_ID; supplies task and WBS detail.
• PA_PROJECTS_ALL — joined on PROJECT_ID; the parent project definition.
• PA_PROJ_ELEMENT_VERSIONS — joined on OBJECT_VERSION_ID; the specific element version the progress applies to.
• PA_PROJ_ELEMENTS — joined on OBJECT_ID; the project element structure.
• PA_PROJECT_STATUSES — joined on STATUS_CODE and PROGRESS_STATUS_CODE; supplies status descriptions.
• HZ_PARTIES — joined on PUBLISHED_BY_PARTY_ID; identifies the party that published the progress entry.

These relationships make PA_PERCENT_COMPLETES a key integration point for project progress reporting, progressive revenue recognition, and reconciliation against the WBS and CBS hierarchies.