Blog Archives

Jumping Employee Number Sequence in Oracle apps

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

update PER_NUMBER_GENERATION_CONTROLS

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

Advertisements