Search Results capacity_over_under

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:

• PA_PROJECT_ASSIGNMENTS — the principal source of team role assignment records.
• PA_RESOURCE_ASSIGNMENTS — supplies resource-level assignment detail.
• PA_PROJECTS_ALL and PA_PROJECT_STATUSES — provide project context and the system status code.
• PA_PROJECT_ROLE_TYPES_TL — the translated project role type lookup joined to yield PROJECT_ROLE and TEAM_ROLE descriptions.
• PA_BUDGET_VERSIONS — supplies BUDGET_VERSION_ID for budget-versioned capacity comparisons.
• PA_RESOURCE_LIST_MEMBERS and PA_RESOURCE — resolve planning resource names and resource identifiers.
• PA_RESOURCE_TXN_ATTRIBUTES — contributes transaction-level attributes for the assignment.
• PER_ALL_PEOPLE_F — resolves PERSON_ID to the person's full name.
• PA_TASK_ASSIGNMENT_UTILS (PACKAGE) — a package dependency, indicating the view or its consumers invoke assignment utility logic, typically for capacity calculation.

Key Columns

• CAPACITY_OVER_UNDER — VARCHAR2(42) indicator expressing whether assigned effort exceeds, meets, or falls short of project capacity. This is the column associated with the search term "capacity_over_under" and is derived from PROJECT_CAPACITY against PLANNED_QUANTITY.
• PROJECT_CAPACITY and PLANNED_QUANTITY — numeric drivers of the over/under comparison.
• PROJECT_ID, PROJECT_ROLE_ID, PROJECT_ROLE, TEAM_ROLE — identify the project and the role being staffed.
• ASSIGNMENT_ID, RESOURCE_LIST_MEMBER_ID, PERSON_ID, RESOURCE_ID, PLANNING_RESOURCE_NAME, PERSON_FULL_NAME — identify the person or resource assigned.
• TASK_ASSIGN_START_DATE, TASK_ASSIGN_END_DATE, TEAM_ROLE_START, TEAM_ROLE_END — assignment and team role date ranges.
• STATUS_CODE, APPRVL_STATUS_CODE, PENDING_APPROVAL_FLAG, MASS_WF_IN_PROGRESS_FLAG, PROJECT_SYSTEM_STATUS_CODE, PA_RECORD_VERSION_NUMBER, ASSIGNMENT_TYPE, SEGMENT1 — status, workflow, concurrency, and miscellaneous control attributes.

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.