Number of Stops and Distance Incorrect for Shipment With Multiple Stops/Ship Units (Doc ID 1539347.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.2.7 to 6.2.9 [Release 6.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Jul-2013***

Symptoms


When updating a shipment with multiple stops and/or multiple ship units, the distance on the shipment is multiplied by this count. This makes the distance incorrect and much higher, eventually can lead to the following exception:

java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column


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