My Oracle Support Banner

"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 JULY 20, 2024

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.