Redwood Bug 25C: Line Manager not appearing correctly after deletion of assignment data

Summary:

We are on 25C

We have multiple assignments.

We know that when you terminate/ end temporary assignment, system inactivates the assignment and hence it also end dates the Line Manager association of the employee with the Line Manager. Because fundamentally Oracle doesn't allow line managers to be supervising inactive assignments.

In our case we have a temporary assignment with a line manager.

When you end the Temp assignment, the system updates the EFFECTIVE_END_DATE in the PER_ASSIGNMENT_SUPERVISORS_F table. It updates it from 12/31/4712 (end of time) to one day before the Temp Assignment is end dated.