My Oracle Support Banner

When Performing Propagate Quantity Changes On OB_SHIP_UNIT Level, the Agent Fails (Doc ID 783027.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


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

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


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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