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… Read More »Oracle HRMS SQL Query to find out Employee and their Supervisor Hierarchy
HRMS
Articles related to HRMS of this blog.
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… Read More »API to Purge/Delete Employee from HRMS application
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… Read More »Setup to enable Effective Date Tracking popup in Oracle HRMS
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… Read More »List of Profile Options in Oracle HRMS R12
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… Read More »How to get iRecruitment Vacancy details in Oracle HRMS before Vacancy is approved.