My Oracle Support Banner

"Cannot delete the ORDER_RELEASE record. A S_SHIP_UNIT_LINE record references it in its [ORDER_RELEASE_GID] column." - Error When Deleting Order Via Integration (Doc ID 988786.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 5.5 to 6.0 [Release 5.5 to 6]
Information in this document applies to any platform.

Symptoms


An Order was created by EBS integration, where the shipment was created then unassigned. A new Delivery (order release) was created from the same Order Line. After this was done, when attempting to Unassign an Order Release, the following message is encountered:

"Selected order releases were already unassigned"

Yet, when trying to delete the Order Release, the following message is encountered:

Cannot delete the ORDER_RELEASE record. A S_SHIP_UNIT_LINE record references it in its [ORDER_RELEASE_GID] column.

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


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