Search Results pa_project_parties




Overview
Explore in AI Chat

Overview

The PA_PROJECT_PARTIES table is a core data object within the Oracle E-Business Suite Projects module (PA). It serves as the central repository for defining and managing all resources involved in a specified project. In the context of Oracle Projects, a "party" is a broad term encompassing any individual, team, or entity assigned to a project, such as employees, contractors, equipment, or job roles. This table establishes the fundamental link between a project (PA_PROJECTS_ALL) and the resources (PA_RESOURCES) that can be assigned to it, forming the basis for project staffing, assignment tracking, and security grant management.

Key Information Stored

The table's primary purpose is to uniquely identify a resource's involvement with a specific project. Its key columns, as indicated by its foreign key relationships, include PROJECT_PARTY_ID (the primary key), PROJECT_ID (linking to PA_PROJECTS_ALL), RESOURCE_ID (linking to PA_RESOURCES), and RESOURCE_TYPE_ID (linking to PA_RESOURCE_TYPES). A critical column is GRANT_ID, which links to FND_GRANTS. This relationship integrates the Oracle Applications Object Security Model, allowing project-specific data security grants (like view, update, or full access) to be assigned directly to the project party. This enables fine-grained control over which users can see or modify project data based on their role within the project team.

Common Use Cases and Queries

This table is essential for reporting on project team composition, validating assignments, and administering security. A common query retrieves all active resources for a given project, joining to resource and person tables for details:

  • SELECT pp.project_id, pp.resource_id, r.resource_name, rt.resource_type FROM pa_project_parties pp, pa_resources r, pa_resource_types rt WHERE pp.project_id = :p_project_id AND pp.resource_id = r.resource_id AND pp.resource_type_id = rt.resource_type_id;

Another critical use case involves troubleshooting data access issues by examining the security grants associated with project parties. Analysts often query the link between a project party and its corresponding grant in FND_GRANTS to understand why a user may or may not have access to certain project data. The table is also fundamental for any process that creates or validates project assignments, as the PA_PROJECT_ASSIGNMENTS table references a PROJECT_PARTY_ID.

Related Objects

PA_PROJECT_PARTIES sits at the center of a key data model, with extensive relationships documented in the ETRM. Its primary foreign key dependencies are: PA_PROJECTS_ALL (on PROJECT_ID), PA_RESOURCES (on RESOURCE_ID), PA_RESOURCE_TYPES (on RESOURCE_TYPE_ID), and FND_GRANTS (on GRANT_ID). Furthermore, it is referenced as a parent table by several critical assignment and history tables, which store the detailed work plans and changes for the project party. These child tables include: PA_PROJECT_ASSIGNMENTS (on PROJECT_PARTY_ID), PA_ASSIGNMENTS_HISTORY (on PROJECT_PARTY_ID), PA_PROJECT_ASGMTS_AR (on PROJECT_PARTY_ID), PA_ASGMTS_HSTRY_AR (on PROJECT_PARTY_ID), and PA_PROJECT_SUBTEAM_PARTIES (on OBJECT_ID in a bidirectional relationship).