Auto Assignment Rule Attempting to Insert ORDER_RELEASE_INV_PARTY Record Twice Upon Order Create Event

(Doc ID 1385627.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.0 and later   [Release: 6 and later ]
Information in this document applies to any platform.

Symptoms

Configured Auto Assignment Rule to assign Order Release Involved party on Order Release creation fails, the following error occurs.

ERROR
-----------------------
Cannot insert the ORDER_RELEASE_INV_PARTY record. INVOLVED_PARTY_QUAL_GID must be set. java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (GLOGOWNER.PK_ORDER_RELEASE_INV_PARTY) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create an Auto Assignment Rule.

Auto Assign Type ID: ORDER_RELEASE_INVOLVED_PARTY
Run on Create: TRUE
Event: ORDER - CREATED
Assign: <Desired Involved Party>

2. Create an Order Release.

3. Check logs.

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