Results for “pa_proj_progress_attr_u2”

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

Overview

PA.PA_PROJ_PROGRESS_ATTR is a transactional configuration table in the Oracle Projects (PA) schema that stores progress setup information for project structures. It controls how progress is collected and reported against a project, including the progress cycle applied, the enabled collection methods (work quantity, remaining effort, percent complete), and the next scheduled progress reporting date. Each row is keyed to a project and an associated structure object, allowing progress behavior to be defined at the structure level rather than globally.

Based on the foreign key relationships documented in the ETRM metadata, the table references PA.PA_PROJ_ELEMENTS via OBJECT_ID and PA.PA_BILLING_CYCLES via PROGRESS_CYCLE_ID. The heuristic Data Vault classification derived from the FK structure is link, suggesting that this table functions principally as an associative entity connecting a project, a structure object, and a progress cycle. In Oracle EBS 12.1.1 and 12.2.2, it is a core configuration source for progress reporting and integration with Oracle Project Management and Team Member functionality.

Key Information Stored

The table contains 19 documented columns. The most significant include:

• PROJ_PROGRESS_ATTR_ID — System-generated surrogate primary key that uniquely identifies each progress attribute record. It is enforced by the unique index PA_PROJ_PROGRESS_ATTR_U1 and the primary key constraint PA_PROJ_PROGRESS_ATTR_PK.
• PROJECT_ID — Identifier of the project to which the progress setup applies.
• OBJECT_ID and OBJECT_TYPE — Identify the structure object (for example, 'PA_STRUCTURES') whose progress behavior is being configured.
• STRUCTURE_TYPE — Specifies the structure type, forming part of the composite business key.
• PROGRESS_CYCLE_ID — Identifier of the progress cycle used by the project to report progress; references PA_BILLING_CYCLES.
• WQ_ENABLE_FLAG — Indicates whether work quantity collection is enabled.
• REMAIN_EFFORT_ENABLE_FLAG — Indicates whether effort collection is allowed.
• PERCENT_COMP_ENABLE_FLAG — Indicates whether percent complete collection is allowed.
• NEXT_PROGRESS_UPDATE_DATE — The next reporting date derived from the progress cycle.
• TASK_WEIGHT_BASIS_CODE — The weighting basis used by the Process Work Breakdown Structure process.
• ALLOW_COLLAB_PROG_ENTRY — Controls whether progress may be entered through the Team Member Home page.
• ALLOW_PHY_PRCNT_CMP_OVERRIDES — Controls whether Physical % Complete may be overridden.
• RECORD_VERSION_NUMBER — Optimistic locking version counter.

Standard Who columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) support auditing and concurrency. The business-key candidate is the composite unique index PA_PROJ_PROGRESS_ATTR_U2 over (PROJECT_ID, OBJECT_ID, OBJECT_TYPE, STRUCTURE_TYPE), distinct from the surrogate PROJ_PROGRESS_ATTR_ID.

Common Use Cases and Queries

Typical use cases include determining which progress methods are enabled for a project, identifying the next progress update date, and auditing progress configuration across structures. A common query retrieves progress setup for a specific project:

• SELECT PROJECT_ID, OBJECT_ID, OBJECT_TYPE, PROGRESS_CYCLE_ID, WQ_ENABLE_FLAG, REMAIN_EFFORT_ENABLE_FLAG, PERCENT_COMP_ENABLE_FLAG, NEXT_PROGRESS_UPDATE_DATE FROM PA.PA_PROJ_PROGRESS_ATTR WHERE PROJECT_ID = :project_id;
• Join to PA_BILLING_CYCLES on PROGRESS_CYCLE_ID to resolve cycle names for reporting progress schedules.
• Join to PA_PROJ_ELEMENTS on OBJECT_ID to link progress attributes to structure elements.
• Filter on NEXT_PROGRESS_UPDATE_DATE to forecast upcoming progress reporting obligations.
• Aggregate enabled flag combinations to analyze organization-wide progress collection practices.

Related Objects

• PA.PA_PROJ_ELEMENTS — Referenced via OBJECT_ID; provides the structure element context.
• PA.PA_BILLING_CYCLES — Referenced via PROGRESS_CYCLE_ID; supplies the progress cycle definition.
• PA.PA_PROJECTS — Parent project entity related through PROJECT_ID.
• PA.PA_PROGRESS_CYCLES (progress cycle logic) — Underlies NEXT_PROGRESS_UPDATE_DATE derivation.
• PA.PA_STRUCTURES — Structure object type referenced by OBJECT_TYPE and OBJECT_ID.
• PA.PA_TASKS — Related through project and structure context for progress collection.

The table is central to progress reporting configuration and is accessed by Oracle Projects progress management and Team Member Home progress entry processes.