My Oracle Support Banner

Questions On Updating Maxvalue Of Sequence WSH.WSH_EXCEPTIONS_S To 9999999999. (Doc ID 2648610.1)

Last updated on NOVEMBER 04, 2022

Applies to:

Oracle Shipping Execution - Version 12.2.8 and later
Information in this document applies to any platform.


Would like to update the maxvalue of sequence WSH.WSH_EXCEPTIONS_S to 9999999999.
Currently it is having a value of 2147483647.


1) Please confirm whether there is any negative impact in doing this?

2) We will update the max value using the following alter sequence statement:

Please advise if there is any other recommended way.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.