Results for “hrfv_supervisors”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HRFV_SUPERVISORS is an APPS-owned, VALID business view within the PER (Human Resources) product family in Oracle EBS 12.1.1 and 12.2.2. Per the ETRM metadata, it is described as a "business view template from which the flexfield view is generated." It is a read-only view (defined WITH READ ONLY) that presents a flattened, reporting-friendly projection of assignment, person, supervisor, organization, and location data.

Its primary purpose is to expose supervisor relationships alongside descriptive attributes for the employee's assignment and supervisor. Because it joins translated tables and applies security profile filtering, it serves as a convenient source for reporting tools, integrations, and custom concurrent programs that need supervisor context without reconstructing the complex joins themselves. The view's structure — denormalized columns for both the person and their supervisor — makes it particularly suited to HR reporting and analytics.

Underlying Base Objects

The view is defined over several base and supporting objects, including:

• PER_PEOPLE_X (PEO) — the person view supplying the employee's full name and employee number.
• PER_ASSIGNMENTS_X (ASS) — the assignment view supplying assignment number, assignment ID, supervisor ID, organization, and business group IDs.
• PER_ALL_PEOPLE_F (SUP) — the supervisor person record (outer-joined on SUPERVISOR_ID), supplying supervisor name, current employee flag, internal location, mailstop, and email.
• HR_ALL_ORGANIZATION_UNITS_TL (ORGT, BGRT) — translated organization names for the assignment's organization and the business group.
• HR_LOCATIONS_ALL_TL (LOCT) — translated location details; this is the source of the LOCATION_NAME column.
• HR_BIS (Package) — supplies lookup decoding (BIS_DECODE_LOOKUP) and the security profile business group function (GET_SEC_PROFILE_BG_ID).

The query filters to current employees (CURRENT_EMPLOYEE_FLAG = 'Y') with a non-null employee number and assignment type 'E'. Language-sensitive joins use USERENV('LANG') to return translated descriptions.

Key Columns

• BUSINESS_GROUP_NAME — name of the business group organization.
• PERSON_NAME / EMPLOYEE_NUMBER — the employee's full name and employee number.
• ASSIGNMENT_NUMBER — the assignment identifier.
• SUPERVISOR_NAME — full name of the supervisor.
• SUPERVISOR_CURRENT_EMP_FLAG — decoded YES/NO flag indicating whether the supervisor is a current employee.
• SUPERVISOR_INTERNAL_LOCATION / SUPERVISOR_MAILSTOP / SUPERVISOR_EMAIL_ADDRESS — contact attributes for the supervisor.
• ORGANIZATION_NAME — name of the assignment's organization unit.
• LOCATION_NAME — the location code (LOCT.LOCATION_CODE), the column most relevant to the user's "location_name" search.
• ASSIGNMENT_ID, BUSINESS_GROUP_ID, PERSON_ID, SUPERVISOR_ID — key identifiers for joins and drill-downs.

Common Use Cases and Queries

Typical uses include supervisor/employee relationship reporting, org-and-location directories, and integration extracts. For example, to retrieve supervisors with their locations and organizations:

• SELECT person_name, employee_number, supervisor_name, location_name, organization_name FROM apps.hrfv_supervisors;
• SELECT supervisor_name, supervisor_email_address, location_name FROM apps.hrfv_supervisors WHERE organization_name = :p_org;

Because the view already applies security profile filtering and current-employee restrictions, consumers avoid re-implementing that logic. Note the view is read-only and returns business group names and location codes directly, making it well suited to reporting layer consumption without additional lookups.