Search Results pa_proj_progress_attr_pk

Overview

The PA_PROJ_PROGRESS_ATTR table is a core data repository within the Oracle E-Business Suite (EBS) Projects module (PA). Its primary function is to store configuration and setup information related to progress tracking for project structures. This table is essential for defining how progress is measured, reported, and billed against specific project elements, acting as a central link between a project's work breakdown structure and its associated progress and billing cycles. Its role is foundational for enabling earned value management, progress-based billing, and performance analysis in Oracle Projects.

Key Information Stored

The table's structure centers on linking a project element to its progress configuration. The key columns, as indicated by the metadata, include:

• PROJ_PROGRESS_ATTR_ID: The primary key identifier for each unique progress setup record.
• OBJECT_ID: A foreign key column linking to PA_PROJ_ELEMENTS. This identifies the specific project task or element to which the progress attributes apply.
• PROGRESS_CYCLE_ID: A foreign key column linking to PA_BILLING_CYCLES. This defines the billing or progress cycle (e.g., monthly, milestone-based) used for this project element.

While the provided metadata is concise, typical implementations of this table may also store attributes such as the progress calculation method (e.g., cost, effort, units), the progress verification rule, and other control flags governing how progress data is captured and processed for the associated project element.

Common Use Cases and Queries

This table is central to queries that analyze or report on project progress setup. Common use cases include auditing the progress configuration for a project, generating setup reports, and supporting data fixes. A typical query would join PA_PROJ_PROGRESS_ATTR to the project tasks and billing cycles to provide a comprehensive view.

Sample SQL Pattern:
SELECT ppa.proj_progress_attr_id,
pe.element_name AS task_name,
bc.cycle_name AS progress_cycle
FROM pa_proj_progress_attr ppa,
pa_proj_elements pe,
pa_billing_cycles bc
WHERE ppa.object_id = pe.proj_element_id
AND ppa.progress_cycle_id = bc.billing_cycle_id
AND pe.project_id = :p_project_id;
This query retrieves the progress cycle assigned to each task for a given project, which is crucial for understanding billing and progress reporting schedules.

Related Objects

As defined by its foreign key constraints, PA_PROJ_PROGRESS_ATTR has direct and critical dependencies within the Projects schema:

• PA_PROJ_ELEMENTS: The primary relationship. This table defines the project tasks and structure. The foreign key (OBJECT_ID) ensures every progress attribute set is attached to a valid project element.
• PA_BILLING_CYCLES: Defines the frequency and rules for billing and progress reporting. The foreign key (PROGRESS_CYCLE_ID) links the project element's progress setup to a specific cycle.
• PA_PROJ_PROGRESS_ATTR_PK: The primary key constraint on PROJ_PROGRESS_ATTR_ID, ensuring the uniqueness of each configuration record.

This table is also integral to the underlying logic of Oracle Projects' progress-related APIs, user interfaces for progress setup, and standard progress reporting functionalities.