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