My Oracle Support Banner

In a Pick Release Batch, Delivery Numbers are not being Created and Assigned Sequentially (Doc ID 315615.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Shipping Execution - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform. Executable:WSHREL - Pick Release


There are gaps in the delivery number sequence assignment assigned to deliveries during a single pick release process.

The following queries can be run to verify:

1) select delivery_id,to_char(creation_date,'MM/DD/YYYY HH24:MI:SS')
from wsh_new_deliveries
where delivery_id > delivery_id;

2) select last_number
from all_sequences
where sequence_name='WSH_NEW_DELIVERIES_S'


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.