This discussion is archived
5 Replies Latest reply: Nov 17, 2013 11:42 PM by Avinash RSS

Supervisor ID updation

888976 Newbie
Currently Being Moderated

Hi,

 

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

 

Thanks,

Naveen.

  • 1. Re: Supervisor ID updation
    Avinash Journeyer
    Currently Being Moderated

    Hi Naveen,

     

    I would use update mode. What is the issue with 2 records in assignment. I think its logical and valid also.

     

     

    Thanks,

    Avinash

  • 2. Re: Supervisor ID updation
    888976 Newbie
    Currently Being Moderated

    Hi Avinash,

     

    Thanks for your response.

     

    Having 2 records in assignment is logical, and I'm agree with that.

    But for the first record, supervisor_id is not getting updated and it will be NULL in per_all_assignments_f table.

     

    Thanks,

    Naveen.

  • 3. Re: Supervisor ID updation
    Avinash Journeyer
    Currently Being Moderated

    Hi Naveen,

     

    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.

     

    Thanks,

    Avinash

  • 4. Re: Supervisor ID updation
    888976 Newbie
    Currently Being Moderated

    Hi Avinash,

     

    My data will be as below if I used UPDATE mode:

     

    effective_start_dateeffective_end_datesupervisor_id
    8-Sep-20029-Jan-2003123
    10-Jan-200314-Mar-2003
    15-Mar-2003            31-Dec-4712456

     

    How can I update the record created in between?

     

    Thanks,

    Naveen.

  • 5. Re: Supervisor ID updation
    Avinash Journeyer
    Currently Being Moderated

    Hi Naveen,

     

    First identify who was the manager for the period 10-Jan-2003 and 14-Mar-2003, then change the system date to 10-Jan-2003 not enter the supervisor detail. System will ask you update option, select option "Insert". This will solve your problem.

     

    Thanks,

    Avinash

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points