Search Results pa_role_lists




Overview
Explore in AI Chat

Overview

The PA_ROLE_LISTS table is a core reference table within the Oracle E-Business Suite Projects module (PA). It serves as the master repository for all role lists defined within the system. A role list is a named grouping of project roles, such as Project Manager, Team Lead, or Consultant, which can be associated with project templates, specific projects, or team templates. This centralization allows for the standardized assignment and management of role-based responsibilities and security across the Projects application, ensuring consistency in project setup and team structuring.

Key Information Stored

The primary data stored in PA_ROLE_LISTS includes the unique identifier and descriptive attributes for each defined role list. While the full column list is not detailed in the provided metadata, the structure is anchored by the primary key column, ROLE_LIST_ID. This unique numeric identifier is the critical foreign key referenced by numerous other tables in the module. Other typical columns would include a ROLE_LIST_NAME for the list's descriptive title, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for audit purposes. The table's sole purpose is to define the list container itself; the specific roles that are members of each list are stored in the related child table, PA_ROLE_LIST_MEMBERS.

Common Use Cases and Queries

The primary use case for PA_ROLE_LISTS is to support the definition and assignment of standardized role sets. Administrators create role lists that are then applied to project templates, enabling new projects to inherit a predefined team structure. Common reporting and validation queries involve joining this table to its related objects. For instance, to identify all projects using a specific role list, one would query: SELECT proj.segment1 project_number, proj.name FROM pa_projects_all proj, pa_role_lists rl WHERE proj.role_list_id = rl.role_list_id AND rl.role_list_name = '<LIST_NAME>';. Another frequent query audits role list usage by joining to PA_ROLE_LIST_MEMBERS to see the full composition of each list.

Related Objects

As indicated by the foreign key relationships, PA_ROLE_LISTS is a central reference point for several key tables. The PA_PROJECTS_ALL table references it via ROLE_LIST_ID to assign a role list to a specific project. The PA_TEAM_TEMPLATES table similarly uses it to define roles within a reusable team template. Most directly, the PA_ROLE_LIST_MEMBERS table is a child table that holds the individual role entries (members) for each list, linked by ROLE_LIST_ID. This relationship means that PA_ROLE_LISTS defines the list header, while PA_ROLE_LIST_MEMBERS stores the detailed lines. Any customization or data fix involving project roles must consider this hierarchical relationship.

  • Table: PA_ROLE_LISTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ROLE_LISTS,  object_name:PA_ROLE_LISTS,  status:VALID,  product: PA - Projects ,  description: PA_ROLE_LISTS stores lists of roles defined with the system. ,  implementation_dba_data: PA.PA_ROLE_LISTS , 

  • Table: PA_ROLE_LISTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ROLE_LISTS,  object_name:PA_ROLE_LISTS,  status:VALID,  product: PA - Projects ,  description: PA_ROLE_LISTS stores lists of roles defined with the system. ,  implementation_dba_data: PA.PA_ROLE_LISTS , 

  • Table: PA_ROLE_LIST_MEMBERS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ROLE_LIST_MEMBERS,  object_name:PA_ROLE_LIST_MEMBERS,  status:VALID,  product: PA - Projects ,  description: PA_ROLE_LIST_MEMBERS stores the information about the roles which make up the role list ,  implementation_dba_data: PA.PA_ROLE_LIST_MEMBERS , 

  • Table: PA_ROLE_LIST_MEMBERS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ROLE_LIST_MEMBERS,  object_name:PA_ROLE_LIST_MEMBERS,  status:VALID,  product: PA - Projects ,  description: PA_ROLE_LIST_MEMBERS stores the information about the roles which make up the role list ,  implementation_dba_data: PA.PA_ROLE_LIST_MEMBERS , 

  • Table: PA_TEAM_TEMPLATES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TEAM_TEMPLATES,  object_name:PA_TEAM_TEMPLATES,  status:VALID,  product: PA - Projects ,  description: PA_TEAM_TEMPLATES stored details of the team templates. The templates are system-wide and accessible to all with appropriate privileges within the system. ,  implementation_dba_data: PA.PA_TEAM_TEMPLATES , 

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_TEAM_TEMPLATES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TEAM_TEMPLATES,  object_name:PA_TEAM_TEMPLATES,  status:VALID,  product: PA - Projects ,  description: PA_TEAM_TEMPLATES stored details of the team templates. The templates are system-wide and accessible to all with appropriate privileges within the system. ,  implementation_dba_data: PA.PA_TEAM_TEMPLATES , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • View: PA_TEAM_TEMPLATES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TEAM_TEMPLATES_V,  object_name:PA_TEAM_TEMPLATES_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_TEAM_TEMPLATES_V , 

  • View: PA_TEAM_TEMPLATES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TEAM_TEMPLATES_V,  object_name:PA_TEAM_TEMPLATES_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_TEAM_TEMPLATES_V , 

  • View: PA_PROJECTS_PRM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECTS_PRM_V,  object_name:PA_PROJECTS_PRM_V,  status:VALID,  product: PA - Projects ,  description: Single-Org ,  implementation_dba_data: APPS.PA_PROJECTS_PRM_V , 

  • View: PA_PROJECTS_PRM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECTS_PRM_V,  object_name:PA_PROJECTS_PRM_V,  status:VALID,  product: PA - Projects ,  description: Single-Org ,  implementation_dba_data: APPS.PA_PROJECTS_PRM_V ,