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.
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;
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