You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Confirming Supplier Sequence Behavior - Skips Duplicate Numbers?

in Supplier Management

Hi all,

We have a client that has imported several suppliers via integration, which have numbers in advance of the Oracle sequence. They are no longer creating suppliers via this integration, but the concern is what happens when the numbers collide?

Made up Example: Existing Supplier created via Integration has Supplier Number 5000, Oracle Sequence is at 4034.

What will happen when they get 866 more suppliers and the Oracle Sequence tries to use 5000? Will Oracle skip to the next available sequence number (5001?) or will Oracle not be able to handle this and throw an error, where the users have to manually push the sequence forward ahead of 5000?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!