Assigning Delivery To Delivery Detail Fails With Unexpected Error: ORA-01407: Cannot Update ("WSH"."WSH_TRIP_STOPS"." STOP_LOCATION_ID") to NULL
(Doc ID 2805623.1)
Last updated on OCTOBER 28, 2022
Applies to:
Oracle Shipping Execution - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
When attempting to assign delivery detail lines to a new delivery, the following error occurs:
Note that most of the lines were assigned to the delivery before pick releasing.
The problem happens when trying to assign the lines that were not included to the same delivery.
ERROR
-----------------------
Oracle Error - 1 User-Defined Exception
Unexpected Error: Error in Routine WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP,
Oracle Error - - 1407
ORA-01407: cannot update ("WSH"."WSH_TRIP_STOPS"."STOP_LOCATION_ID") to NULL
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Shipping responsibility
2. Navigate to Shipping Transactions form
3. Select the non-assigned lines
4. Click on Actions > Assign to Delivery
5. Select the delivery
6. Error occurs
Changes
Upgrade from release 12.1.3 to 12.2.9.
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 |
Changes |
Cause |
Solution |
References |