"Cannot add the GTM_TRANS_LINE_QUANTITY record. [GTM_TRANSACTION_LINE_GID, GTM_QUANTITY_TYPE_GID] must be unique" Exception When Sending Ship Confirm of Delivery from EBS to GTM

(Doc ID 2316746.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle Global Trade Management - Version 6.4.2 to 6.4.3 [Release 6.4]
Oracle Transportation Management - Version 6.4.2 to 6.4.3 [Release 6.4]
Information in this document applies to any platform.

Symptoms

Within EBS, when attempting to ship confirm a delivery which has serialized items with individual serial numbers, multiple ship items are created based on the individual serial numbers.  The resulting EBS XML has multiple SHIPITEM elements with the same delivery detail number.  This results in the translation of the EBS XML to GTM XML with identical TransactionLine elements.  When sending the delivery to OTM/GTM, the transmission fails processing at OTM/GTM with the below exception.

Note:  This issue is not seen in case of serialized items with range serial numbers.


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