Delivery Export Compliance Screening Creates Duplicate XML SHIPITEMS For Delivery Details In ITM Adapter
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.
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:
IMessageClass = E
IMessageCode = TRANSACTION_EXCEPTION
IMessageText = CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION:
 [SQL_STATEMENT] insert into gtm_trans_line_quantity
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
ORA-00001: unique constraint (GLOGOWNER.UK_GTLQ_GTM_TRNSLN_TYPE_GID) violated at
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.
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