Shipment ID Generated Not Following Default Sequence And Then Fills Sequence Gap Days Later (Doc ID 2064814.1)

Last updated on FEBRUARY 17, 2016

Applies to:

Oracle Transportation Management Cloud Service - Version 6.3.4 to 6.3.4 [Release 6.3]
Oracle Transportation Operational Planning Cloud Service - Version 6.3.4 to 6.3.4 [Release 6.3]
Oracle Transportation Management - Version 6.3.4 to 6.4.0 [Release 6.3 to 6.4]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
The Shipment IDs generated are not following a default sequence.  

It is noticed that days later that the sequence gap is then filled.

For example, the DB sequence generates Shipment ID 1,3,& 6 today and 4, 5, 10 tomorrow or the next day.

 

EXPECTED BEHAVIOR 
---------------

The Shipment IDs would always be in sequence.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms