In a Pick Release Batch, Delivery Numbers are not being Created and Assigned Sequentially
(Doc ID 315615.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Shipping Execution - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]Information in this document applies to any platform.
***Checked for relevance on 12-NOV-2015***
Executable:WSHREL - Pick Release
Symptoms
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'
Cause
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
| Symptoms |
| Cause |
| Solution |