Search Results pa_progress_rollup

Overview

The PA_PROGRESS_ROLLUP table is a core data repository within the Oracle E-Business Suite Projects module (PA). It serves as the central storage for aggregated progress information across project tasks and work breakdown structures (WBS). Its primary role is to support the progress tracking and earned value management (EVM) functionalities by maintaining rolled-up metrics, such as cost and revenue, from lower-level tasks up through the project hierarchy. This enables project managers to analyze performance at summary levels and is critical for generating accurate project status reports and financial forecasts.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which link it to major project entities. The primary key, PROGRESS_ROLLUP_ID, uniquely identifies each rolled-up record. Key columns include PROJECT_ID, linking to PA_PROJECTS_ALL, and OBJECT_ID paired with OBJECT_VERSION_ID, which reference a specific task or structure element (PA_PROJ_ELEMENTS) and its version (PA_PROJ_ELEMENT_VERSIONS). The table stores progress against a PROGRESS_STATUS_CODE (referencing PA_PROJECT_STATUSES). Crucially, it holds financial data in multiple currencies, using TXN_CURRENCY_CODE (referencing FND_CURRENCIES) and conversion rate types (PROJFUNC_COST_RATE_TYPE, PROJ_COST_RATE_TYPE) linked to GL_DAILY_CONVERSION_TYPES. Additional columns, implied by its purpose, would store the rolled-up numerical values for actual cost, budgeted cost, revenue, and quantities.

Common Use Cases and Queries

This table is primarily accessed for project performance analysis and audit reporting. Common use cases include generating earned value reports, analyzing cost and schedule variance for a project summary, and reconciling rolled-up totals with detailed transaction data. A typical query would join to project and task tables to retrieve progress by WBS level.

• Sample SQL Pattern: Retrieving rolled-up cost for top-level project elements:
  SELECT ppr.PROJECT_ID, pev.VERSION_NAME, ppr.PROGRESS_STATUS_CODE, ppr.ROLLED_ACTUAL_COST
FROM PA.PA_PROGRESS_ROLLUP ppr,
    PA.PA_PROJ_ELEMENT_VERSIONS pev
WHERE ppr.OBJECT_VERSION_ID = pev.ELEMENT_VERSION_ID
AND ppr.PROJECT_ID = :p_project_id
AND pev.VERSION_TYPE = 'STRUCTURE';
• Data in this table is typically populated by background processes like "Update Project Summary Amounts" or "Calculate Project Performance." Direct manipulation is not recommended; integration should occur via standard public APIs.

Related Objects

PA_PROGRESS_ROLLUP has integral relationships with numerous foundational Projects tables, as defined by its foreign keys. Key dependencies include:

• PA_PROJECTS_ALL: The master project definition.
• PA_PROJ_ELEMENTS & PA_PROJ_ELEMENT_VERSIONS: The task or structure element and its version for which progress is rolled up.
• PA_PROJECT_STATUSES: The status (e.g., Approved, Pending) applied to the progress.
• FND_CURRENCIES & GL_DAILY_CONVERSION_TYPES: Currency and rate type definitions for the stored financial amounts.
• Related APIs: Progress calculation and summarization logic is typically encapsulated within Oracle's Project Analysis (PA) packages, such as PA_COST_PROCESS.