My Oracle Support Banner

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


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.

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"."

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


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.