"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 JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5 to 6.0 - Release: 5.5 to 6
Information in this document applies to any platform.
***Checked for relevance on 22-Sep-2011***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms