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:

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

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