My Oracle Support Banner

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

Last updated on JULY 02, 2018

Applies to:

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


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


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


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.