Universally, are you simply reassigning all active employees to another supervisor before the supervisor it termed? Common practice in JOB is to look at the supervisor being termed, and if that person has people assigned to them, before the term record is entered, the employees affected are reassigned to another person, and then the supervisor is termed clean. You also need to see if there are any approvals in the mix, and reassign the task as well before the supervisor term row is entered.

All this is because you do not have Position Management, and if you did, then the empty supervisor box will automatically up the task the that supervisors Reports To as long as the Org Chart is all connected top to bottom.

Before Jane 2 was Termed, John should have been reassigned to an active new manager.

Good luck, and let us know how this was resolved. Have a great day.

David L

Hi TJR,

It depends on the reporting on those employees.
Access type 5 combines Position Reporting and Supervisor Reporting. Position
Reporting is by job. So, if someone has 2 jobs and one is inactivated, that reporting will be removed from the table when someone else takes that position. That row in PS_HR_DIRECT_REP_5 is used for drilling down to indirect reports but skipped when getting supervisor.
Supervisor reporting is to a person, so if the person is still active in any position the direct reports still report to them.

So, if you want people reporting to a person no matter what job is active use the supervisor id in Job. If you want them to stop reporting when the manager's job is inactivated, you should use position reporting.

As far as using the table directly, the table is used for drilling down and getting supervisor. These 2 functions are very different, so the methods are the best way to access the data. You will need to review the methods to make sure they get the correct information if your query the table directly.

Thanks,

Bhuvana