Order Mod Integration to Remove ReleaseLine And ShipUnit Fails with "ORA-02292: integrity constraint (GLOGOWNER.FK_SSUL_SHIP_UNIT_LINE) violated - child record found"
Last updated on MAY 15, 2017
Applies to:Oracle Transportation Management Cloud Service - Version 6.3.4 to 6.3.4 [Release 6.3]
Oracle Transportation Operational Planning Cloud Service - Version 6.3.4 to 6.3.4 [Release 6.3]
Oracle Transportation Management - Version 6.3.2 to 6.4.2 [Release 6.3 to 6.4]
Information in this document applies to any platform.
An Order Mod Integration to remove ReleaseLine and ShipUnit fails
When sending a transmission that includes a Release and an ActualShipment transaction and which should remove a ReleaseLine and ShipUnit from the release and a Shipment Ship Unit from the shipment, the Release transaction fails with an error saying that the ship unit gid is referenced by an s_ship_unit record.
The s_ship_unit record that is referenced is one that wasn't on the shipment before the transaction was processed. The Release transaction code is RC.
The ManagedChild elements of ReleaseLine and ShipUnit are being used, as well as the IntCommand, RemoveShipmentRefForRC.
RemoveShipmentRefForRC is supposed to prevent this error from occurring.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms