Missing Records in PER_MANAGER_HRCHY_CF After Refresh Manager Hierarchy Process

Hi All,

We are consistently encountering an issue where records for certain active employees are missing from the PER_MANAGER_HRCHY_CF table, after the Refresh Manager Hierarchy scheduled process completes successfully.

However, the corresponding employee records are available in the PER_ALL_ASSIGNMENTS_M table.

For example:

• For active employee 7041057, the records are missing from PER_MANAGER_HRCHY_CF on a particular day.
• The same records appears in the table the following day, but records for other active employees are then found to be missing.
• This behavior is occurring daily, affecting different active employees.

Initially, we considered this an intermittent issue, but it has now become a recurring problem.