Search Results pa_project_subteam_parties




Overview
Explore in AI Chat

Overview

The PA_PROJECT_SUBTEAM_PARTIES table is a core data structure within the Oracle E-Business Suite Projects module (PA). Its primary function is to manage the association between project parties—such as team members, suppliers, or customers—and specific project subteams. A subteam is a logical grouping within a larger project team, often used to organize resources by function, phase, or geography. This table acts as a junction or intersection table, linking the master definitions of project parties (from PA_PROJECT_PARTIES) with the defined subteam structures (from PA_PROJECT_SUBTEAMS). Its role is critical for enabling detailed resource management, security, and reporting at a granular, subteam level within complex project hierarchies in both EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on foreign key relationships that define the association. While the full column list is not detailed in the provided metadata, the foreign key constraints explicitly identify the essential columns. The PROJECT_SUBTEAM_ID column references the PA_PROJECT_SUBTEAMS table, identifying the specific subteam. The OBJECT_ID column references the PA_PROJECT_PARTIES table, identifying the specific project party or assignment being added to the subteam. Typically, such an intersection table would also include metadata columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track audit information. The table's existence implies it stores one record for each unique party-to-subteam assignment.

Common Use Cases and Queries

This table is central to operations involving subteam-based project staffing and access control. A common use case is generating a report of all parties assigned to a particular project subteam for resource planning. Another is validating security rules where data access is restricted by subteam membership. A typical query would join this table to PA_PROJECT_SUBTEAMS and PA_PROJECT_PARTIES to get a comprehensive list.

  • Sample Query: SELECT s.SUBTEAM_NAME, pp.PARTY_NAME FROM pa_project_subteam_parties psp, pa_project_subteams s, pa_project_parties pp WHERE psp.project_subteam_id = s.project_subteam_id AND psp.object_id = pp.object_id AND s.project_id = :p_project_id;
  • Reporting: Reports on subteam composition, resource allocation across subteams, and audit trails of party assignments to subteams all rely on this table.

Related Objects

As indicated by its foreign keys, PA_PROJECT_SUBTEAM_PARTIES has direct, dependent relationships with two primary tables. It is a child table of PA_PROJECT_SUBTEAMS, which defines the subteam headers. It is also a child table of PA_PROJECT_PARTIES, which is the master repository for all parties (e.g., persons, organizations, assignments) associated with a project. This table is likely referenced by various Project Foundation and Resource Management APIs, as well as by standard Oracle Projects forms and reports that handle subteam assignments. Any custom interfaces or extensions that create or manage subteam membership would also interact with this table.