Oracle Fusion HCM:VISA lookups

1) Sign into the application with a user who has access to Setup and Maintenance(IT Security Manager) 2.  Navigator > Setup and Maintenan...

Oracle fusion HCM :"List of Direct Report"

The query can be based  on PER_MANAGER_HRCHY_DN table and fetch based on the manger_id by passing person id of the manager and manager level...

Oracle Fusion HCM :Employee Emergency Contact

  You can use  " Workforce Management - Person Real Time Subject Area" and Check in the Section " Person Contact Relationshi...

Oracle Fusion HCM :Area Of Responsbility

 Note:  Area of responsibilities is NOT part of security roles (Duty or Job Role) it is separate from Security Profile.  SELECT DISTINCT pap...

Oracle Fusion HCM: Department Query

SELECT hauft.NAME FROM   HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft WHERE   ha...

Oracle Fusion HCM:Absence Management Query

SELECT aapf.absence_plan_id, aapft.NAME   FROM anc_absence_plans_f_tl aapft, anc_absence_plans_f aapf  WHERE aapft.absence_plan_id = aapf.ab...

Oracle fusion HCM:Employee Query

SQL Query to Fetch Employees SELECT papf.person_number, hauft.name businessunit   FROM hr_org_unit_classifications_f houcf,        hr_all_or...

Oracle Fusion HCM:Salary basis is not appearing in List of Values while creating employee

 Steps :   1)Create element(standard) for particular LDG   2)Attach element(which was created in step1) for the LDG which was specified in s...