Search Results pa_reqmnt_competences_amg_v




Overview
Explore in AI Chat

Overview

PA_REQMNT_COMPETENCES_AMG_V is a reporting and integration view in the Oracle E-Business Suite Applications (APPS) schema, owned by the Projects (PA) product family. The view presents the complete set of competences associated with a project requirement. In this context a "requirement" corresponds to an open project assignment. The view therefore exposes the competences that a given project assignment demands, together with the associated proficiency (rating level) and whether each competence is mandatory. Because it consolidates data across the Projects and Human Resources (PER) schemas, it is intended for reporting, inquiry, and integration scenarios where a denormalized, read-only representation of requirement competences is required. The object is documented as a VIEW with STATUS VALID across 12.1.1 and 12.2.2, and the underlying ETRM metadata is consistent between the two releases regarding owner and referenced base objects.

Underlying Base Objects

The view is defined over five documented base objects, all accessed through APPS synonyms: PA_PROJECTS_ALL, PA_PROJECT_ASSIGNMENTS, PER_COMPETENCES, PER_COMPETENCE_ELEMENTS, and PER_RATING_LEVELS. The join logic is significant:

Key Columns

The view publishes the following columns (view text aliases shown in parentheses where applicable):

Common Use Cases and Queries

Typical uses include requirement competency reporting, staffing gap analysis, and exposing competences to integration or BI layers. A basic query lists all competences for a specific project requirement:

  • SELECT requirement_id, requirement_name, competence_name, competence_alias, rating_level_value, mandatory_flag FROM pa_reqmnt_competences_amg_v WHERE requirement_id = :assignment_id;
  • SELECT project_number, project_name, requirement_name, competence_name, rating_level_value FROM pa_reqmnt_competences_amg_v WHERE project_id = :project_id ORDER BY requirement_name, competence_name;
  • SELECT requirement_name, competence_name FROM pa_reqmnt_competences_amg_v WHERE mandatory_flag = 'Y'; — isolate mandatory competences.

Because PER_RATING_LEVELS is outer-joined, reports should tolerate null RATING_LEVEL_VALUE. All access should be read-only via the APPS synonym; the view is not intended as a DML target.