My Oracle Support Banner

Tracking Event Number Is Larger Than Internal OTM Code Can Handle (Doc ID 1544907.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.1.5 and later
Information in this document applies to any platform.

Symptoms

Agent updates utilizing an 'out of box' OTM action are failing because the code cannot handle the size of the TE numbers.
(TRACKING EVENT TO SHIPMENT) - COPY RECEIVED FIELDS TO SHIPMENT - Update Ship Unit Information
The tracking event numbers have reached the max value.

The Stack Trace received in the logs: "Error is obtaining ie_s_ship_unit and ie_s_ship_unit_line for shipment SNI/IM.SI103333240/transaction_no 2147485254 java.sql.SQLException: Numeric Overflow"

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
References


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.