Results for “pa_rep_org_comp_sum_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_REP_ORG_COMP_SUM_V is a reporting view in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema. It consolidates competency and resource information at the intersection of organization, competence, and person. Its documented purpose is to present an organization competence summary, making it a convenient source for reporting the distribution of competencies across an organization's schedulable resource pool.

The view's relevance to the search term schedulable_flag is direct. It exposes a derived SCHEDULABLE_FLAG column sourced from the PA_RESOURCES_DENORM table. The value is passed through a DECODE expression: a NULL schedulable flag is normalized to 'N', while any non-null value is returned unchanged. This means downstream reports can rely on the column always carrying a definite value ('Y' or 'N') rather than a nullable one. In EBS 12.1.1 and 12.2.2 the view remains defined over the PER and PA resource/competency tables and behaves consistently as a read-only reporting object.

Underlying Base Objects

The view text joins several PER and PA objects, several of which are accessed via synonyms in the APPS schema:

• PER_COMPETENCES (synonym) — provides competence identity, name, alias, and description.
• PER_COMPETENCE_ELEMENTS (synonym) — links competencies to persons; the count of persons per competence is derived here.
• PER_COMPETENCE_DEFINITIONS (synonym) — supplies the descriptive flexfield segments (SEGMENT1 through SEGMENT30).
• PA_RESOURCES_DENORM (synonym) — the denormalized resource table supplying SCHEDULABLE_FLAG, UTILIZATION_FLAG, RESOURCE_PERSON_TYPE, and effective dates.
• HR_ORGANIZATION_UNITS (view) — supplies the organization ID and name.
• PER_BUSINESS_GROUPS (view) — joined via an outer join to supply the business group name.
• PER_PEOPLE_F (view) — used to confirm the person exists.

Documented dependencies also include the packages HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY, reflecting the use of date-tracked and secured HR data.

Key Columns

• ORGANIZATION_ID, NAME (org) — the organization and its name.
• COMPETENCE_ID, NAME, COMPETENCE_ALIAS, DESCRIPTION — competence attributes.
• SCHEDULABLE_FLAG — normalized schedulable indicator ('Y'/'N'), NULL mapped to 'N'.
• RESOURCE_PERSON_TYPE — the person type of the resource.
• Count of COMP_ELE.PERSON_ID — headcount of persons holding the competence.
• SEGMENT1 through SEGMENT30 — competence definition flexfield segments.
• Business group NAME (BUS).

Common Use Cases and Queries

Typical uses include headcount-by-competency reporting, schedulable resource roll-ups, and filtering competency coverage by organization.

SELECT ORGANIZATION_ID, NAME, COMPETENCE_ID,
       COMPETENCE_ALIAS, SCHEDULABLE_FLAG
FROM   APPS.PA_REP_ORG_COMP_SUM_V
WHERE  SCHEDULABLE_FLAG = 'Y'
ORDER BY ORGANIZATION_ID, COMPETENCE_ID;

The view applies an inner join to PA_RESOURCES_DENORM with UTILIZATION_FLAG = 'Y' and restricts resources to those whose latest effective record is active as of SYSDATE, so results reflect currently effective and utilizable resources only. Reports should therefore treat the output as a point-in-time summary of schedulable competency coverage.