Search Results supervisor_number




Overview
Explore in AI Chat

Overview

The APPS.HRFV_PROBATIONS view is a business view template delivered within the PER — Human Resources product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its documented description states that it is a "business view template from which the flexfield view is generated." This places the object within the Oracle HRMS descriptive flexfield reporting framework, where seeded templates such as HRFV_PROBATIONS supply the underlying SQL that drives flexfield-enabled business views exposed to end users and integrators. The view presents probation-related assignment data for employees, combining probation start and end dates, the probation period unit and length, organizational context, and — critically for the query that surfaced this object — supervisor identification, including the SUPERVISOR_NUMBER column sourced from the supervisor's employee number.

Practically, the view functions as a reporting and integration surface for human resources administrators tracking employee probation cycles across business groups and organizations. Because it is defined WITH READ ONLY, it supports query-only access, making it safe for ad hoc reporting, BI Publisher datasets, and interface extracts.

Underlying Base Objects

The documented metadata lists the following referenced base objects: HR_ALL_ORGANIZATION_UNITS_TL (synonym), HR_BIS (package), HR_DISCOVERER (package), HR_GENERAL (package), HR_PERSON_NAME (package), HR_SECURITY (package), PER_ALL_ASSIGNMENTS_F (synonym), PER_ALL_PEOPLE_F (synonym), PER_PEOPLE_X (view), and PER_PERIODS_OF_SERVICE (synonym). The view text confirms that the primary driving table is PER_ALL_ASSIGNMENTS_F, aliased ASG, filtered on ASSIGNMENT_TYPE = 'E' (employee assignments) and on rows where either PROBATION_UNIT or DATE_PROBATION_END is populated. PER_ALL_PEOPLE_F supplies supervisor name and employee number through the outer-joined alias SUP, while PER_PEOPLE_X supplies the employee's own person record. PER_PERIODS_OF_SERVICE links the assignment to its period of service. HR_ALL_ORGANIZATION_UNITS_TL is joined twice — once for the assignment organization and once for the business group. Several PL/SQL packages are invoked during row evaluation: HR_DISCOVERER.CHECK_END_DATE for the derived probation end date, HR_BIS.BIS_DECODE_LOOKUP for frequency and Yes/No decoding, and HR_BIS.GET_SEC_PROFILE_BG_ID for business group security filtering. HR_SECURITY, HR_GENERAL, and HR_PERSON_NAME are also referenced in the broader object definition.

Key Columns

Common Use Cases and Queries

Typical uses include probation tracking reports, supervisor-based dashboards, and interface extracts requiring the supervisor's employee number. A basic query retrieving employees on probation with their supervisor number is:

SELECT person_name, supervisor_name, supervisor_number, organization_name, probation_start_date, probation_end_date FROM apps.hrfv_probations WHERE supervisor_number = :p_supervisor_number;

To list all current probationers ordered by end date:

SELECT business_group_name, person_name, probation_end_date, probation_units FROM apps.hrfv_probations ORDER BY probation_end_date;

Because the view enforces business group security through GET_SEC_PROFILE_BG_ID and is read-only, it is suited to secured, ad hoc reporting without risk of data modification.