Delivery Integration to OTM Failing with Error: THE FOREIGN KEY ELEMENT Length.LengthUOMGid WITH VALUE CUFT COULD NOT BE FOUND IN TABLE UOM COLUMN UOM_CODE (Doc ID 467208.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5.03
This problem can occur on any platform.

Symptoms

-- Problem Statement:
Sending a delivery (order release) transmission to OTM is failing with the following error:

The foreign key element Length.LengthUOMGid with value CUFT could not  be found in table UOM column uom_code.

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