Order Mod Integration To Update Pack Confirmation Fails With "ORA-02292: Integrity Constraint"
Last updated on MAY 08, 2018
Applies to:Oracle Transportation Management - Version 6.4.1 and later
Information in this document applies to any platform.
When sending a transmission that includes a Release and a ActualShipment transaction, that 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 reference is one that wasn't on the shipment before the transaction was processed. The Release transaction code is RC. We're using the ManagedChild elements of ReleaseLine and ShipUnit, 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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms