My Oracle Support Banner

WSH_NEW_DELIVERIES_S Sequence Max Value Will Soon Be Reached. Is It Okay to Make New Max Value? (Doc ID 2253727.1)

Last updated on AUGUST 14, 2018

Applies to:

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

Goal

Noticed that WSH_NEW_DELIVERIES_S - Sequence "Max Value" is going to reach the max value mentioned in the existing sequence.

Existing Max Value: 2147483647
New Max Value to Change: 9999999999

Please confirm if we can change the max value to New Max Value if there is any impact in the code.  

 

To verify the Max Value of the sequence, run the following query:

select * from all_sequences
where sequence_name = 'WSH_NEW_DELIVERIES_S';

 

To verify the last delivery value used to see how close to the max value you are, run the following query:

select max(delivery_id) from wsh_new_deliveries;

 

 

Solution

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
Goal
Solution
References


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