"Change Service Provider" Actions Failing With Exception: "Cannot add the SHIPMENT_INVOLVED_PARTY record."
(Doc ID 1192543.1)
Last updated on MARCH 04, 2019
Applies to:Oracle Transportation Management - Version 6.1.0 and later
Information in this document applies to any platform.
Multiple involved parties are assigned to an Order which are then copied over to the shipment. When the actions 'change service provider' or 'chose least cost' are executed, the following error occurs:
Error Exception Cannot add the SHIPMENT_INVOLVED_PARTY record. SHIPMENT_GID, INVOLVED_PARTY_QUAL_GID, INVOLVED_PARTY_CONTACT_GID, COM_METHOD_GID must be unique.
java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT_INVOLVED_PARTY) violated
The issue can be reproduced at will with the following steps:
1. Create Order release
Against: Involved party tab, add involved party contact as well involved party locations
2. Create order movements for this Order Release
3. Select the related order movements and click action > Bulk plan
4.View the Shipments created and note the involved party contacts as well involved party locations get copied from order release post shipment creation.
5. Now use shipment action > Shipment management > Change service provider > Choose least cost OR Select and change service provider.
6. This throws error as shown above
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