Delivery Export Compliance Screening Creates Duplicate XML SHIPITEMS For Delivery Details In ITM Adapter

(Doc ID 2317563.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Intl Trade Mgmt Integration

Intermittently, when attempting to ship the sales orders, some Deliveries are creating duplicate XML SHIPITEMS for the same Delivery Details in the International Trade Management(ITM) Adapter.  In turn, the Global Trade Management(GTM) Transaction is rejected with the following error:



ERROR
-----------------------

WrittenBy = TRANSACTION_PROCESSOR
IMessageClass = E
IMessageCode = TRANSACTION_EXCEPTION
IMessageText = CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION:
[092957] [SQL_STATEMENT] insert into gtm_trans_line_quantity
(gtm_trans_line_qty_seq_no,domain_name,gtm_transaction_line_gid,uom_code,quantity_value,gtm_quantity_type_gid)
 values (?,?,?,?,?,?) at [19768730, LMTM, LMTM.4846892_D, EA, 1, ORDERED]

Cannot add the GTM_TRANS_LINE_QUANTITY record. [GTM_TRANSACTION_LINE_GID, GTM_QUANTITY_TYPE_GID] must be unique.
java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.UK_GTLQ_GTM_TRNSLN_TYPE_GID) violated
java.sql.BatchUpdateException:
ORA-00001: unique constraint (GLOGOWNER.UK_GTLQ_GTM_TRNSLN_TYPE_GID) violated at

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Enter and book sales order
3. Shipping > Release sales Orders > Pick Release order
4. Line workflow goes to Delivery Export Compliance screening.
5. The XML file that was sent to GTM is rejected with the above error.

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