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 20, 2024

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

	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

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

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)

Applies to:

Symptoms

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!