Wrong Default Value In EQUIPMENT_TYPE Table (Doc ID 1593617.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On OTM version 6.3.2

The column EXTERIOR_HEIGHT_UOM_CODE in the EQUIPMENT_TYPE table has a default value of 'NOT NULL'.

This is causing the following exception to appear repeatedly in the logs during planning:
2013-10-01 15:07:25.907 252407 Error Exception Unable to convert NOT NULL to MM

More details about the log entry can be found in the attachment.

Other UOM_CODE columns in that table have a default value of 'NUlL' and this is not causing an issue.



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