Results for “per_competence_elements_v”
42 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PER_COMPETENCE_ELEMENTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the PER (Human Resources) product family. As documented in the ETRM metadata, the view is "used to support user interface," meaning it serves as a denormalized, presentation-oriented projection over the competence element data model rather than as a transactional object. In EBS 12.1.1 and 12.2.2, views of this class are typically consumed by Oracle Forms-based self-service and professional user interfaces, as well as by custom reports and integrations that require human-readable descriptions instead of raw foreign-key identifiers. The view joins the base competence element rows to their translated lookup tables so that a single SELECT returns decoded names for competencies, proficiency rating levels, jobs, grades, positions, organizations, activity versions, and person names. This design reduces client-side join logic and enforces consistent decode behavior across the application.
Underlying Base Objects
The view's FROM clause draws on several documented base objects. The driving table is PER_COMPETENCE_ELEMENTS, joined to PER_COMPETENCES and PER_COMPETENCES_TL for the competence name (CPL.NAME). Proficiency and high-proficiency levels are resolved through two aliased instances of PER_RATING_LEVELS (RATL1, RATL2) and their translation table PER_RATING_LEVELS_TL (RTL1, RTL2), which supply the STEP_VALUE and NAME used to build the displayed proficiency string. Person attributes are sourced from PER_PEOPLE_F, grade and job descriptions from PER_GRADES_TL and PER_JOBS_TL, valid grades from PER_VALID_GRADES, and activity versions from OTA_ACTIVITY_VERSIONS. Organization data is resolved via HR_ALL_ORGANIZATION_UNITS_TL and the HR_ORG_UNITS_NO_JOIN view. Security and naming are enforced through the HR_SECURITY, HR_PERSON_NAME, and HR_GENERAL packages, while FND_SESSIONS supplies runtime session context, notably the business group filter.
Key Columns
The view exposes COMPETENCE_ELEMENT_ID (the primary key), BUSINESS_GROUP_ID, ENTERPRISE_ID, and OBJECT_VERSION_NUMBER for concurrency control. COMPETENCE_ID and the derived competence name identify the skill or competency being tracked. PROFICIENCY_LEVEL_ID and HIGH_PROFICIENCY_LEVEL_ID are the foreign keys to PER_RATING_LEVELS; the view displays them as concatenated STEP_VALUE and NAME strings, which is directly relevant to the user's search on rating_level_id. PERSON_ID, JOB_ID, VALID_GRADE_ID, POSITION_ID, and ORGANIZATION_ID provide the assignment context, each accompanied by a decoded description. MANDATORY, COMPETENCE_TYPE, CERTIFICATION_DATE, CERTIFICATION_METHOD, NEXT_CERTIFICATION_DATE, and SOURCE_OF_PROFICIENCY_LEVEL capture certification and proficiency-source detail, with lookups decoded through HR_GENERAL.DECODE_LOOKUP. Twenty ATTRIBUTE flexfield columns and standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the structure.
Common Use Cases and Queries
Typical usage includes competency gap reports, certification tracking, and self-service profile extracts. A query to retrieve elements with decoded proficiency by rating level would take the following form:
SELECT competence_element_id, person_id, full_name, competence_id, proficiency_level_id, mandatory FROM per_competence_elements_v WHERE business_group_id = :p_bg_id;SELECT competence_element_id, competence_id, proficiency_level_id, high_proficiency_level_id FROM per_competence_elements_v WHERE proficiency_level_id = :p_rating_level_id;
Because the view applies business group and security filtering through FND_SESSIONS and HR_SECURITY, queries should always constrain or initialize the session context to avoid returning incomplete or unauthorized rows. When only raw rating level identifiers are required, joining PER_RATING_LEVELS and PER_RATING_LEVELS_TL directly to PER_COMPETENCE_ELEMENTS may be preferable for performance; the view remains the correct choice when decoded, UI-ready output is required.
-
Used to support user interface
APPS.PER_COMPETENCE_ELEMENTS_V·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore PER module →
-
Used to support user interface
APPS.PER_COMPETENCE_ELEMENTS_V·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore PER module →
-
SYNONYM: APPS.PER_GRADES_TL 12.1.1
-
SYNONYM: APPS.PER_GRADES_TL 12.2.2
-
SYNONYM: APPS.PER_JOBS_TL 12.1.1
-
SYNONYM: APPS.PER_JOBS_TL 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
SYNONYM: APPS.FND_SESSIONS 12.1.1
-
SYNONYM: APPS.FND_SESSIONS 12.2.2
-
VIEW: APPS.PER_PEOPLE_F 12.1.1
-
VIEW: APPS.PER_PEOPLE_F 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person