Error: Cannot Update the SHIP_UNIT_LINE - When Updating an Order With Lines of 0 Weight/Volume

(Doc ID 558746.1)

Last updated on JULY 09, 2014

Applies to:

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

Symptoms

-- Problem Statement:

When a Release update (integration), that contains Weight/Volumes of 0, is provided and the agent action OMD - Edit Shipment is executed, the following error is presented:

Cannot update the SHIP_UNIT_LINE record. WEIGHT must be set.
java.sql.SQLException: ORA-01407: cannot update ("GLOGOWNER"."SHIP_UNIT_LINE"."WEIGHT") to NULL


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