Order Mod Integration to Remove ReleaseLine And ShipUnit Fails with "ORA-02292: integrity constraint (GLOGOWNER.FK_SSUL_SHIP_UNIT_LINE) violated - child record found" (Doc ID 2077179.1)

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.

Symptoms

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.

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