My Oracle Support Banner

Integration of Update XML With RC Transaction Code Errors With "java.sql.SQLIntegrityConstraintViolationException" (Doc ID 2090296.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Transportation Management - Version 6.3.7 to 6.4.2 [Release 6.3 to 6.4]
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, that indicates the ship unit gid is referenced by an s_ship_unit record.  The s_ship_unit record that is reference is one that was not on the shipment before the transaction was processed.  The Release transaction code is RC.  The process is using the ManagedChild elements of ReleaseLine and ShipUnit, as well as the IntCommand, RemoveShipmentRefForRC.  RemoveShipmentRefForRC that should prevent this error from occurring. 




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.