Error: Cannot Update the SHIP_UNIT_LINE - When Updating an Order With Lines of 0 Weight/Volume
Last updated on JULY 09, 2014
Applies to:Oracle Transportation Management - Version: 5.5.03.03
This problem can occur on any platform.
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
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