WSH_NEW_DELIVERIES_S Sequence Generating Delivery_ids in Large Gaps Since R12 Implementation (Doc ID 1665930.1)

Last updated on MARCH 01, 2024

Applies to:

Symptoms

On : 12.1.3 version

Have observed during the R12 implementation that the WSH_NEW_DELIVERIES_S sequence is generating delivery_ids with large gaps.
The sequence is not always incrementing by 1 as expected. It mostly increments by 1 but then will increment by just less than 1000.
In order to eliminate confusion and possible errors in processing shipments, the delivery_ids need to be as sequential as possible.

The issue does not occur in the 11i instance. Users use the Shipping Transactions Form (STF) to autocreate deliveries. 

THis is an example of the large gap on 25-March:
Date                          DELIVERY     ORG
25-MAR-2014 13:06   410457         282
25-MAR-2014 13:06   410458         282
25-MAR-2014 13:06   410459         282
25-MAR-2014 13:07   410460         282
25-MAR-2014 13:07   410461         282
25-MAR-2014 13:07   410462         282
25-MAR-2014 13:31   410463         284
25-MAR-2014 13:34   410464         284
25-MAR-2014 13:39   410465         284
25-MAR-2014 13:40   410466         284
25-MAR-2014 13:58   410467         282
25-MAR-2014 13:59   410468         282
==> gap of 989 occurs here
25-MAR-2014 18:00   411457         282
25-MAR-2014 18:01   411458         282
25-MAR-2014 18:06   411459         282

 STEPS

-----------------------
The issue can be reproduced as follows:
1) Open the Shipping Transactions Form (STF)
2) Select a Detail
3) Select Actions--Autocreate Delivery
4) Do this many times then wait some time (few hours)
5) Then Select Actions--Autocreate Delivery again and delivery id has a large gap

Cause

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