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...

Oracle EBS Order Management :Schedule Arrival Date

 When will schedule arrival date will populates? Note that the Schedule Arrival Date will only be calculated when the Sales Order Order, Dat...

Oracle EBS: AR System options -show billing period importance

 Importance of  Show billing period importance in Receivables Once you enable this system option, Billing Number field is displayed on the f...