My Oracle Support Banner

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

Last updated on APRIL 19, 2024

Applies to:

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

Goal

WSH_NEW_DELIVERIES_S sequence, Max Value, will soon be reached. Confirm if the existing max value can be changed to a New Max Value, if so would there be any impact in the code caused by such a change?

 

Note: 

Reaching maximum value can also happen for the following sequences : Example - WSH_DELIVERY_DETAILS_S, WSH_DELIVERY_ASSIGNMENTS_S

 

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

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.