Search Results pa_rep_org_com_res_lst_v




Overview
Explore in AI Chat

Overview

PA_REP_ORG_COM_RES_LST_V is an Oracle Projects (PA) reporting view owned by the APPS schema. It presents a consolidated resource listing organized by organization and competence, allowing reporting tools and integrations to retrieve schedulable project resources together with their competence, proficiency level, managerial, and job-related attributes in a single flat structure. The view is one of the denormalized reporting constructs supplied with Oracle E-Business Suite and is classified as VALID in both 12.1.1 and 12.2.2. Because it joins person, competence, job, and organization data across the HR and Projects schemas, it removes the need for report developers to reconstruct those joins manually. It is typically consumed by custom reports, Oracle BI Publisher layouts, Discoverer worksheets, and interfaces that need a competence-aware roster of project resources. Notably, the column exposing proficiency is derived from PER_RATING_LEVELS.STEP_VALUE and is surfaced in the view as PROFICIENCY_LEVEL, which is the term users most often search for when investigating this object.

Underlying Base Objects

The view is defined over the following documented objects:

The join path links competence elements to resource records by PERSON_ID, and resources to organizations by RESOURCE_ORGANIZATION_ID. An inline subquery on PA_RESOURCES_DENORM selects the earliest effective resource row whose end date is still open, ensuring a single current resource record per person.

Key Columns

Common Use Cases and Queries

A typical report filters by organization and competence to list qualified resources with their proficiency levels. The query below honors the SYSDATE-based date filters already built into the view:

SELECT organization_name,
       person_name,
       competence_name,
       proficiency_level,
       job_name,
       schedulable_flag,
       location
FROM   apps.pa_rep_org_com_res_lst_v
WHERE  organization_id = :p_org_id
AND    competence_id   = :p_competence_id
ORDER  BY proficiency_level DESC, person_name;

Other common scenarios include identifying resources at or above a given proficiency threshold for staffing decisions, auditing schedulable versus non-schedulable resources by organization, and feeding downstream applications that require competence-to-resource mappings. Because HR_SECURITY packages participate in the definition, results are inherently subject to the calling user's HR security profile, so report consumers see only the organizations and people they are authorized to view.