Category Archives: HRMS

Articles related to HRMS of this blog.

Oracle HRMS SQL Query to find out Employee and their Supervisor Hierarchy

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 SELECT LEVEL, e.* FROM (SELECT DISTINCT papf.person_id, papf.employee_number, papf.full_name "EMPLOYEE_FULL_NAME", paaf.supervisor_id, papf1.employee_number "SUPERVISOR_EMP_NUMBER", papf1.full_name "SUPERVISOR_FULL_NAME" FROM apps.per_all_people_f papf, apps.per_all_assignments_f paaf, apps.per_all_people_f papf1, apps.per_person_types ppt WHERE papf.person_id = paaf.person_id AND papf1.person_id =… Read More »

API to Purge/Delete Employee from HRMS application

You can use API HR_PERSON_API.DELETE_PERSON to delete an employee(person) and the associated person related records. Example: DECLARE — Input Variables l_validate BOOLEAN := FALSE; l_effective_date DATE := sysdate; l_person_id NUMBER := 123048; l_perform_predel_validation BOOLEAN := FALSE; — Output Variables l_person_org_manager_warning VARCHAR2(2000); BEGIN — Calling API HR_PERSON_API.DELETE_PERSON hr_person_api.delete_person(p_validate => l_validate , p_effective_date => l_effective_date , p_person_id… Read More »

Setup to enable Effective Date Tracking popup in Oracle HRMS

In Oracle HRMS by default when we navigate to ‘People’ form a window pops up asking to change effective date. This window pops up based on a profile option ‘DateTrack:Reminder‘. This profile option should be configured with value “Always pop warning window”

List of Profile Options in Oracle HRMS R12

List of Profile Options in Oracle HRMS R12 Profile Option Internal Name AME:Installation Level AME_INSTALLATION_LEVEL AME:Installed AME_INSTALLED_FLAG Apply Assessment Competencies to Person HR_APPLY_COMPETENCIES_TO_PERSON Display Messages NL_DISPLAY_MESSAGE HR: Absence Duration Auto Overwrite PER_ABSENCE_DURATION_AUTO_OVERWRITE HR: Absence Start Date HR_FR_ABSENCE_START_DATE HR: Absence View Layout HR_VIEWS_LAYOUT_ABSENCE HR: Accrual Plan Element Set Displayed to User PER_ACCRUAL_PLAN_ELEMENT_SET HR: Actions – Validation… Read More »

How to get iRecruitment Vacancy details in Oracle HRMS before Vacancy is approved.

Generally details of Vacancies created in Oracle iRecruitment are store in ‘PER_ALL_VACANCIES’ table. But you cant see the vacancy details in ‘PER_ALL_VACANCIES’ table if the vacancy is NOT approved. Where does Vacancy details get stored  before Approval/Rejection As soon as vacancy is created the vacancy related data goes and resides in some temporary tables. This… Read More »