5 Replies Latest reply on Nov 18, 2013 7:42 AM by iavinash.com

    Supervisor ID updation




      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.


      Sample data:

      emp_no: 123

      emp new assignment's effective_start_date = 10-JAN-2003

      new supervisor's effective_start_date = 15-MAR-2003