My Oracle Support Banner

'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 NOVEMBER 06, 2020

Applies to:

Oracle Transportation Management Cloud Service - Version 20.2 and later
Information in this document applies to any platform.

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

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.