'Cannot delete the ORDER_RELEASE_LINE_T record. A S_SHIP_UNIT_LINE_T record references it in its [OR_LINE_GID] column' Error When Updating Order Release (Doc ID 2726841.1)

Last updated on AUGUST 05, 2024

Applies to:

Symptoms

When an Order is planned on a Shipment, sending an update transmission to delete an Order Release Line (and associated Ship Unit/S Ship Unit) results in an error:

Step to reproduce the issue:
1. Load XML file 'INTEGRATION_1' (Order has 3 lines)
2. Plan Order into Shipment
3. Load XML file 'INTEGRATION_1 UPDATE' (deletes 1 line successfully by setting quantity to 0)
4. Load XML file 'INTEGRATION_1_UPDATE 2' (attempts to delete a 2nd line by setting quantity to 0)
5. You will get an integration error 'delete from order_release_line where order_release_line_gid=?; [DOMAIN.INTEGRATION_1 Cannot delete the ORDER_RELEASE_LINE_T record. A S_SHIP_UNIT_LINE_T record references it in its [OR_LINE_GID] column'

Transaction code 'RC' is being used in the integration and Agent using 'ORDER - MODIFIED' Event with 'Integration' and 'Before Persist' restrictions is using action 'ORDER RELEASE - MOD - EDIT SHIPMENT'.

Cause

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