I'm trying update the new supervisor_id for an employee, who has assigned to new assignment.
Here, the new supervisor's effecive_start_date is greater than the employee assignment's effective_start_date.
As it will be a new record I cant use the date_track_mode as 'CORRECTION'. And If I used 'UPDATE' I will get 2 records in assignments.
Please suggest how to come out of this issue.
emp new assignment's effective_start_date = 10-JAN-2003
new supervisor's effective_start_date = 15-MAR-2003
Who was the supervisor for that employee for the period it is comming NULL. It cannot be new supervisor as his assignment had not started for that period. So whoever was the supervisor for that period make the entry if you donnot want it to be null.