Search Results resource_comp_count




Overview
Explore in AI Chat

Overview

APPS.PA_REP_ORG_RES_COMP_V is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The view presents a denormalized, reporting-oriented projection of project resource data combined with the competencies each resource possesses, organized by the owning organization. Its primary purpose is to serve Oracle Projects reporting and integration requirements where a flattened, ready-to-consume record set is preferred over joining the highly normalized HR and Projects base tables directly.

The view is registered under FND Design Data as PA.PA_REP_ORG_RES_COMP_V and is documented with a status of VALID. It is not referenced by any other database object, confirming that it functions strictly as a terminal reporting artifact rather than a building block for further dependent logic. The name of the view reflects its three principal dimensions: organization (ORG), resource (RES), and competency (COMP). Users searching for the resource_comp_count metric will find it exposed here under the documented column name RESOURCE_COMP_COUNT.

Underlying Base Objects

The view is defined over a combination of APPS synonyms, a view, and packaged PL/SQL functions. The documented dependencies are:

  • PA_RESOURCES_DENORM (synonym) — supplies the denormalized resource attributes such as organization, resource name, manager, job, and billable/schedulable flags.
  • PER_PEOPLE_F (view) — the effective-dated HR person record used to resolve resource names and person types.
  • PER_JOBS (synonym) and PER_JOB_EXTRA_INFO (synonym) — provide job identifiers, job names, job codes, and job level information.
  • PA_HR_COMPETENCE_UTILS (package) — the competency utility used to derive the concatenated competency string and the competency count for each resource.
  • PA_EXPENDITURES_UTILS (package) — projects expenditure utilities referenced within the view definition.
  • HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY (packages) — HR foundation calls used for person naming and, critically, security-based row filtering of the persons visible to the querying user.

Because HR_SECURITY is among the dependencies, the rows returned by the view are subject to the HR security profile of the session, meaning results are naturally constrained to the organizations and persons the user is authorized to see.

Key Columns

Common Use Cases and Queries

Typical uses include competency gap analysis, resource competency inventory reporting, and feeding downstream BI extracts.

  • Resources ranked by competency count within an organization:
SELECT ORGANIZATION_NAME, RESOURCE_NAME, RESOURCE_COMP_COUNT
FROM   APPS.PA_REP_ORG_RES_COMP_V
WHERE  RESOURCE_COMP_COUNT > 0
ORDER  BY RESOURCE_COMP_COUNT DESC;
  • Billable, schedulable resources with their managers and jobs:
SELECT RESOURCE_NAME, MANAGER_NAME, JOB_NAME, JOB_LEVEL
FROM   APPS.PA_REP_ORG_RES_COMP_V
WHERE  BILLABLE_FLAG = 'Y' AND SCHEDULABLE_FLAG = 'Y';
  • Listing competency detail strings for a specific resource or organization:
SELECT ORGANIZATION_NAME, RESOURCE_NAME, RESOURCE_COMPETENCIES, LAST_UPDATED
FROM   APPS.PA_REP_ORG_RES_COMP_V
WHERE  RESOURCE_ID = :p_resource_id;

Because HR_SECURITY governs the view, report authors should expect results to vary by responsibility and security profile.