My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.2.7 to 6.2.9 [Release 6.2]
Information in this document applies to any platform.


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


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

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