"Cannot add the SHIP_COMMIT_ALLOC_JOIN record" Error in Excecution of SHIPMENT EVENT TRACKER Agent (Doc ID 965718.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.0 to 6.0.4 - Release: 6
Information in this document applies to any platform.

Symptoms


-- Problem Statement:

When adding a Shipment Event, the "SHIPMENT EVENT TRACKER" agent is failing with the following  Exception:

Cannot add the SHIP_COMMIT_ALLOC_JOIN record. [SHIPMENT_GID,  COMMIT_ALLOC_USAGE_GID] must be unique.

java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIP_COMMIT_ALLOC_JOIN) violated

The SQL failing is the following:

insert into ship_commit_alloc_join (shipment_gid,commit_alloc_usage_gid,servprov_gid,domain_name) values (?,?,?,?); [DOMAIN.SHIPMENT_GID, DOMAIN.USAGE_GID, DOMAIN.SERVPROV, DOMAIN]

-- Steps To Reproduce:

1. Add Shipment Event to a shipment that is created with Commitment Allocation
2. Have this event trigger the "SHIPMENT EVENT TRACKER" Agent

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