Search Results pa_project_role_types

Overview

The PA_PROJECT_ROLE_TYPES view is a critical data object within the Oracle E-Business Suite (EBS) Projects module (PA). It serves as a language-specific, filtered list of all valid project role types that can be assigned to individuals within project teams. The view is built upon the underlying translatable table PA_PROJECT_ROLE_TYPES_VL, applying a key filter to return only roles belonging to the 'PERSON' party class. This ensures the view presents a clean, application-ready list of human resource roles, excluding other entity types, for use in user interfaces, reporting, and data validation throughout the project management lifecycle.

Key Information Stored

The view provides a comprehensive set of columns for each project role type. The most significant columns include PROJECT_ROLE_TYPE (the internal code), MEANING (the translated name), and DESCRIPTION. The ROLE_PARTY_CLASS is consistently filtered to 'PERSON'. Essential control columns are START_DATE_ACTIVE and END_DATE_ACTIVE for enabling or disabling roles. Configuration columns such as DEFAULT_JOB_ID, DEFAULT_MIN_JOB_LEVEL, and DEFAULT_MAX_JOB_LEVEL define default job constraints for the role. The QUERY_LABOR_COST_FLAG indicates if the role can query labor costs, while DEFAULT_ACCESS_LEVEL and FREEZE_RULES_FLAG control security and rule maintenance. The standard WHO columns (CREATED_BY, LAST_UPDATED_BY, etc.) and 15 flexible Attribute columns are also present for extensibility and audit purposes.

Common Use Cases and Queries

This view is primarily used for populating lists of values (LOVs) in forms where project roles are assigned, such as the Project Team Member and Project Role Assignment screens. It is also fundamental for validation and reporting on project staffing. A typical query retrieves all active roles for a given language, often sorted by their displayed meaning.

• Sample Query for Active Role LOV:
  SELECT meaning, description, project_role_type
  FROM apps.pa_project_role_types
  WHERE language = USERENV('LANG')
  AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE)
  ORDER BY meaning;
• Use Case - Role Configuration Report: Reports analyzing role setup, including default job mappings and access levels, are built directly from this view.
• Use Case - Integration: External systems or data loads reference this view to validate PROJECT_ROLE_TYPE codes before assigning personnel to projects.

Related Objects

PA_PROJECT_ROLE_TYPES is centrally linked to several core Projects tables. It is directly sourced from the PA_PROJECT_ROLE_TYPES_VL table, which holds the base transactional and translated data. The PROJECT_ROLE_TYPE code from this view is a foreign key in assignment tables such as PA_PROJECT_ROLE_ALLOCATIONS. It relates to the PA_PROJECT_PLAYERS table for team member assignments and interfaces with the PER_JOBS table via the DEFAULT_JOB_ID column. This view is also referenced by the underlying OA Framework components and public APIs like the PA_PROJECT_ROLE_PUB package for role management.