Top Oracle HCM Technical Interview Questions for Experienced Candidates

These article questions are based on real interviews and are not general questions.

1] Name a few standard ESS Jobs related to HCM.

Answer: We have many ESS jobs; "Send Pending LDAP Requests" and "Refresh Manager Hierarchy" are a few of them.

2] What is the full form of HDL, and what role is required for a user to upload HDL?

Answer: HDL stands for HCM Data Loader, and "Human Resource Integration Specialist" is the role required to load HDL.

3] Assume an HCM extract is configured with the delivery option set to EMAIL. Can we stop sending the file if the record count is zero?

Answer: Yes, we can stop it by adding conditional check logic to the bursting query.

4] What is the use of the PER_MANAGER_HRCHY_REPORTEES_DN table?

Answer: This table helps to retrieve direct and indirect managers without writing a complex query. It is usually used by the system.

5] Can we submit HDL using HCM Extracts? If yes, what should be the delivery type in the extract?

Answer: Yes, we can submit HDL from HCM Extracts, and the delivery type will be "Data Loader Interface."