When Performing Propagate Quantity Changes On OB_SHIP_UNIT Level, the Agent Fails

(Doc ID 783027.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5.04.04 to 5.5.05.04
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.04.04, When attempting to use the Propagate Changes - Quantity Changes, on an Order base Ship Unit agent, the following error occurs:

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


java.sql.SQLException: ORA-01407: cannot update ("GLOGOWNER"."SHIP_UNIT"."UNIT_LENGTH") to NULL
.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create a buffer order
2. Release it and create an Order movement and then plan it
3. Set up agent to listen for Order Base modification - Quantity changes with action to trigger
Propagate Changes - Quantity Changes
3. Then send in an Order Base modification XML with weight change
4. See that the Propagate changes fails with the error

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