Search Results hrfv_competence_profiles




Overview
Explore in AI Chat

Overview

HRFV_COMPETENCE_PROFILES is an APPS-owned business view template in the PER (Human Resources) product family, defined in Oracle E-Business Suite 12.1.1 and 12.2.2. Unlike a conventional reporting view, this object serves as a flexfield view template: the descriptor columns (_DF and _KF:CMP) exist specifically so that a "flexfield view" can be generated from it, exposing competence element descriptive flexfield segments for downstream use. The view presents a person-centric, flattened picture of competences held by individuals, combining the competence name, the proficiency rating, certification details and the owning business group.

Consumers searching for competence_name are typically querying this view for a human-readable label of a competence held by an employee. Because the view is a template rather than a transactional entity, it is read-only (WITH READ ONLY) and reflects the state of the underlying PER tables at query time, making it well suited to BIS/HRMS reporting, extracts and integration payloads that require employee competence profiles.

Underlying Base Objects

The view is assembled from the following documented base objects:

Key Columns

Common Use Cases and Queries

The view supports competence inventories per person or business group, proficiency distribution analysis, and certification expiry monitoring. Note the embedded security predicate: results are filtered by the caller's security profile business group.

  • Locate competences by name for a person:

SELECT person_name, competence_name, proficiency_level
FROM apps.hrfv_competence_profiles
WHERE competence_name = 'Project Management';

  • List all competences held by an employee:

SELECT competence_name, date_from, date_to, proficiency_level
FROM apps.hrfv_competence_profiles
WHERE person_name = :p_person_name
ORDER BY competence_name;

  • Identify certifications approaching review:

SELECT person_name, competence_name, certification_date, next_review_date
FROM apps.hrfv_competence_profiles
WHERE next_review_date BETWEEN TRUNC(SYSDATE) AND TRUNC(SYSDATE) + 90;

Because the view is read-only and security-filtered, it is safe for ad hoc enquiry and BIS reporting, but should not be treated as an updateable entity in custom code.