How to restrict the absence type list of values in Oracle Self-Service Human Resources.R 12.2.8

 

    Oracle Self-Service HR enables users to apply for absences. When applying for an absence, users enter the absence date or time, absence type, absence status, and absence reason. The absence types (for example, Vacation, Sick Leave etc.) are defined in Oracle HRMS application. Currently, all the absence types defined in Oracle HRMS application are displayed to the self-service user. 

    The user may not be eligible for all the absence types displayed in the self-service application.

    Example, In Our Organization, Unauthorized LWA Should not be viewed in the SSHR - Absence entry page. But the same to be displayed for the Payroll User in Enter & maintain - Absence Screen.

Solution :

    Oracle Self-Service HR introduces a custom package that enables customers to write the logic for deriving the absence type values based on their business requirements.

    Use the following the sample steps to derive a restricted list of values for absence type LOV in Absence Management. The custom logic has to be written in the New Package function HR_ABSENCE_RESTRICTED.ABSENCES_RESTRICTED Login person id and selected person id will be passed by default – using these two parameters the rest of the data or parameters can be queried from the tables.

Step 1: Query the HR_ABSENCE_RESTRICTED Package 

Step 2: Add the below function in the Package Body.

 

function absences_restricted(selected_person_id in varchar2,
         login_person_id in varchar2
         )return varchar2 is
l_sex VARCHAR2 (15) := NULL;

begin

IF to_number(selected_person_id) is not null THEN
 
    select sex into l_sex from per_all_people_f where person_id= to_number(selected_person_id)
    and sysdate between effective_start_date and effective_end_date;
 
        if l_sex = 'F' THEN
        return  '66,3061';
    elsif l_sex = 'M' THEN
    return '65,3061';
    else
    return '66,65,3061';
    END IF;

END IF;

end absences_restricted;
 

The above function is to restrict, the Maternity Leave  view access only to the Female Employees & Paternity Leave view access only to the Male Employees & Restrict Unauthorized LWA Leave for the Both female , male & Others.

Note: In this example, ‘66,3061,66’ are the id of the absence type, which has to restricted.

After Complied this, Go to Employee Self Service, Absence --> Create Absence, In the Absence Type you cant find the Unauthorized LWA Leaves.