Search Results comp_ele




Overview
Explore in AI Chat

Overview

APPS.PA_REQMNT_COMPETENCES_AMG_V is a reporting and integration view in Oracle E-Business Suite that consolidates competency requirement data attached to project assignments. It joins assignment, project, competence, competence element, and rating level information into a single denormalized result set, allowing consumers to retrieve the complete competency profile of an assignment without navigating the individual transactional tables. The view is owned by the APPS schema and is exposed in both release 12.1.1 and 12.2.2, with documented metadata captured in ETRM 12.2.2.

The object is particularly relevant to searches such as "comp_ele" because its driving table is PER_COMPETENCE_ELEMENTS (aliased COMP_ELE), which stores the individual competency element records that link a competence definition to a specific object. The view restricts these records to those whose OBJECT_NAME is 'OPEN_ASSIGNMENT', ensuring only assignment-level requirements are surfaced.

Underlying Base Objects

The view is defined over five referenced base objects, all resolved through synonyms in the APPS schema:

  • PA_PROJECT_ASSIGNMENTS (ASGMT) — supplies the assignment identifier, name, start and end dates, and the parent project reference.
  • PA_PROJECTS_ALL (PROJ) — supplies the project name and the project number (SEGMENT1).
  • PER_COMPETENCE_ELEMENTS (COMP_ELE) — the driving table of the join; holds the competency element identifier, the associated competence, proficiency level, mandatory flag, and audit columns.
  • PER_COMPETENCES (COMP) — supplies the competency name, alias, and business group identifier.
  • PER_RATING_LEVELS (RL) — supplies the numeric step value corresponding to the proficiency level.

The join path is: COMP_ELE.COMPETENCE_ID = COMP.COMPETENCE_ID, COMP_ELE.OBJECT_ID = ASGMT.ASSIGNMENT_ID, ASGMT.PROJECT_ID = PROJ.PROJECT_ID, and COMP_ELE.PROFICIENCY_LEVEL_ID = RL.RATING_LEVEL_ID. The final predicate is an outer join (RL.RATING_LEVEL_ID (+)), so competency elements lacking a valid proficiency level are still returned.

Key Columns

  • OBJECT_ID — the assignment identifier that the competency element is attached to.
  • ASSIGNMENT_NAME, START_DATE, END_DATE — descriptive attributes of the assignment.
  • PROJECT_ID, NAME, SEGMENT1 — project identifier, name, and project number.
  • COMPETENCE_ELEMENT_ID — unique identifier of the competency element record.
  • COMPETENCE_ID, NAME, COMPETENCE_ALIAS — the competence being required and its readable identifiers.
  • PROFICIENCY_LEVEL_ID, STEP_VALUE — the required proficiency level and its numeric rating step.
  • MANDATORY — flag indicating whether the competency is mandatory for the assignment.
  • OBJECT_VERSION_NUMBER, BUSINESS_GROUP_ID, CREATION_DATE, LAST_UPDATE_DATE — concurrency control and audit/ownership columns.

Common Use Cases and Queries

This view is typically used for competency gap analysis, assignment staffing reports, and integration extracts feeding external HR or resource management systems. A straightforward query by project is:

  • SELECT project_id, segment1, assignment_name, name, step_value, mandatory FROM apps.pa_reqmnt_competences_amg_v WHERE segment1 = :project_number;
  • SELECT competence_id, name, step_value FROM apps.pa_reqmnt_competences_amg_v WHERE assignment_name = :assignment AND mandatory = 'Y';
  • SELECT * FROM apps.pa_reqmnt_competences_amg_v WHERE object_id = :assignment_id;

Because the view is defined only over open assignments, it never returns historical or closed assignment competency requirements. Reports requiring proficiency text rather than the numeric STEP_VALUE should join back to PER_RATING_LEVELS explicitly, since only STEP_VALUE is projected here.