5 Replies Latest reply: Nov 18, 2013 1:42 AM by iavinash.com RSS

    Supervisor ID updation

    888976

      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
          iavinash.com

          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

            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
              iavinash.com

              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

                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
                  iavinash.com

                  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