Now we observe we have wrongly created a employee(005736) and we delete and purge the data.
Now we have to maintain the correct sequence so what we do is
Go to Work Structures -> Organization -> Description
Query the organization and go to Additional Organization Information and change the employee Number generation to Manual
Now change the sequence by creating the person as in the below screenshot
So update the sequence as below
set next_value = 5735 –Current Sequence Number
where type = ‘EMP’ — Assuming you are updating the employee number generation to automatic.
and business_group_id = “Your BG ID”;
Now we have to change the next sequence to 005736
After updating the script Now we have to run a concurrent Program
After running the program test it by creating a Employee