While Assigning Delivery To New Line See Error: Unexpected Error: ORA-01407: cannot update ("WSH"."WSH_TRIP_STOPS"." STOP_LOCATION_ID") to NULL
(Doc ID 2805623.1)
Last updated on FEBRUARY 27, 2022
Applies to:
Oracle Shipping Execution - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, WMS, Shipping & Transportation
When attempting to assign lines to the delivery, the following error occurs.
Most of the lines were assigned to the delivery before Pick Release. The problem happens when trying to assign the lines that are not included to the same delivery.
This problem began after upgrading from 12.1.3 to 12.2.9.
ERROR
-----------------------
Unexpected Error: Error in Routine WSH_TP_RELEASE.
calculate_del_tpdates, 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
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 |
Cause |
Solution |
References |