Search Results team_role




Overview
Explore in AI Chat

Overview

APPS.PA_UPDATE_TEAM_ROLES_V is an internal Oracle E-Business Suite view owned by the APPS schema and registered in FND Design Data as PA.PA_UPDATE_TEAM_ROLES_V. It presents project team role assignment data—planned quantities, project capacity, and the derived capacity variance indicator—in a single denormalized structure used by the Project Resource Management (PRM) team role maintenance and approval flows. The view is classified as an Oracle Internal Use Only object: Oracle Corporation does not support direct access to application data through it except from standard Oracle Applications programs. It therefore functions as a supporting data source for the forms, workflows, and concurrent programs that manage team role assignments, rather than as a public reporting interface.

The object carries a VALID status in both 12.1.1 and 12.2.2. Its FND registration and internal view type mean its definition is maintained by Oracle patching and may change without notice between point releases, which is an important consideration for any custom code that references it.

Underlying Base Objects

The documented dependency list for PA_UPDATE_TEAM_ROLES_V includes synonyms and one PL/SQL package:

Key Columns

Common Use Cases and Queries

Typical scenarios include reviewing capacity over/under conditions per team role, diagnosing why an assignment is pending approval, and validating planned quantities against project capacity. Because the object is unsupported for direct query, any diagnostic SQL should be run only under Oracle guidance.

SELECT assignment_id,
       person_full_name,
       project_role,
       planned_quantity,
       project_capacity,
       capacity_over_under
FROM   apps.pa_update_team_roles_v
WHERE  project_id = :p_project_id
AND    capacity_over_under IS NOT NULL;

A second pattern lists team roles awaiting workflow action:

SELECT assignment_id,
       team_role,
       apprvl_status_code,
       pending_approval_flag,
       mass_wf_in_progress_flag
FROM   apps.pa_update_team_roles_v
WHERE  project_system_status_code = 'ACTIVE'
AND    pending_approval_flag = 'Y';

All queries should be executed with the appropriate APPS-level privileges in a controlled environment.