This content has been marked as final. Show 5 replies
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