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

About pacesettergraam

A good and realistic person

Posted on November 2, 2017, in Functional, oracle apps, oracle apps hrms, Technical and tagged , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: