How to solve the Shipping Execution Delivery id sequence issue ?

How to Solve the Shipping Execution Delivery id Sequence issue ?

Requirement :
Oracle Shipping Execution Transaction Delivery id skipping 1000 numbers. User required that should be continues sequence number.

Solution :

Find the cache size using the following sql

select last_number, cache_size from all_sequences where sequence_name = 'WSH_NEW_DELIVERIES_S' ;

You can get the last delivery number and jumping / skipping numbers output

Last_Number      Cache_Size
23025                 1000.

Now update the Cache size as '0'. and test the shipping transaction flow. Delivery id will be continues sequence number.