My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.


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

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


 Upgrade from release 12.1.3 to 12.2.9.


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

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