1 Reply Latest reply: Jul 25, 2013 6:31 PM by Gopinath Ramasamy RSS

    Not able to terminate an Emp, Error: The person must exist as an employee at the time specified by Date Start

    user12168737

      HI Guru's

       

      We are sourcing Employee records from upstream system and the Effective_start_date for particular record of Employee is getting changed, consider a below scenario.

       

      EXISTING RECORD.

      Person_id, effective_start_date,Effective_end_date, person_type

      123,       01-JAN-2001         ,31-MAY-2001,        EMP

      123,       01-JUN-2001         ,31-DEC-4712,        EMP

       

      MODIFIED DRECORD

      Person_id, effective_start_date,Effective_end_date, person_type

      123,       01-JAN-2001         ,14-MAY-2001,        EMP

      123,       15-MAY-2001         ,31-DEC-4712,        EMP

       

      So when i am able to change the effective_start_date for 2nd record from 01-JUN-2001 to 15-MAY-2001 using an API "hr_person_api.update_person" with p_datetrack_update_mode as 'UPDATE_OVERRIDE'..

      but after this when i am trying to terminate the employee using an API "hr_ex_employee_api.actual_termination_emp" for below scenario, i am getting the following error: "The person must exist as an employee at the time specified by Date Start".

       

      For Termination:

      Person_id, effective_start_date,Effective_end_date, person_type

      123,       01-JAN-2001         ,14-MAY-2001,        EMP

      123,       15-MAY-2001        ,09-JUL-2001,        EMP

      123,       10-JUL-2001         ,31-DEC-4712,       EX_EMP  ----> Not able to process erroing

       

      Please help me in resolving this issue..

       

      Regards,

      Mushtaq