Search Results comp_lvl




Overview
Explore in AI Chat

Overview

APPS.PA_GLOBAL_COMPETENCES_LOV_V is a read-only Oracle EBS view that exposes the set of global (business-group-independent) competences that carry at least one defined competence level. It is used primarily as a list-of-values (LOV) source in Project Accounting and related competency-management flows, where end users must select from the pool of competences that are valid across the enterprise rather than within a single business group. Because the view filters on BUSINESS_GROUP_ID IS NULL, it presents only seeded or globally scoped competence definitions, which is the appropriate semantic for cross-business-group assignment and reporting. The view is owned by APPS and is not itself a table; no DML should be issued against it. In Oracle EBS 12.1.1 and 12.2.2 the definition is stable, and the object remains a thin, deterministic projection over Oracle HRMS (PER) competency objects.

Underlying Base Objects

The documented base objects for this view are PER_COMPETENCES (referenced through a synonym) and PER_COMPETENCE_LEVELS_V (a view). The outer query selects from PER_COMPETENCES and restricts the result set with a correlated EXISTS clause against PER_COMPETENCE_LEVELS_V on competence_id. Consequently, the view returns one row per qualifying global competence; duplicate suppression is inherent because EXISTS is a semi-join and does not multiply rows by the number of matching levels. The base product’s competence-level view supplies the level rows used in the semi-join, and only competences that appear there survive the filter. This dependency means the population of PA_GLOBAL_COMPETENCES_LOV_V can shrink if levels are end-dated or deleted, independent of the competence record itself.

Key Columns

  • COMPETENCE_ID — The primary key of the competence in PER_COMPETENCES; the value returned to the calling form or report as the LOV selection, and the join key to the level view.
  • COMPETENCE_ALIAS — The short alias/code for the competence, typically used in integrations and cross-reference mapping.
  • NAME — The user-facing competence name displayed in the LOV and in reports.
  • DESCRIPTION — The free-text description of the competence, useful for tooltips and documentation output.

All four columns are projected directly from PER_COMPETENCES; no aggregation or derived columns are introduced. Note that the view does not expose BUSINESS_GROUP_ID because the predicate guarantees it is null for every returned row.

Common Use Cases and Queries

Typical uses include populating an LOV in a Project Accounting competency assignment form, validating a competence identifier supplied through an interface table, and producing reference extracts of global competences for downstream systems. A straightforward listing follows:

SELECT competence_id,
       competence_alias,
       name,
       description
  FROM apps.pa_global_competences_lov_v
 ORDER BY name;

To confirm that a specific competence is globally scoped and level-enabled before interfacing it:

SELECT competence_id, name
  FROM apps.pa_global_competences_lov_v
 WHERE competence_alias = :p_alias;

To count the available global competences for a validation report:

SELECT COUNT(*) FROM apps.pa_global_competences_lov_v;

Because the underlying sources are PER objects, access is governed by HRMS security and the APPS schema grants. Queries should be run as APPS or through a synonym with appropriate privileges, and the view should be treated as read-only in all cases.