My Oracle Support Banner

'Cannot add the GTM_TRANS_REQD_REVIEWER_T record. [GTM_TRANSACTION_GID, DOCUMENT_DEF_GID, CONTACT_GID] must be unique' When Running AES Compliance Rule on GTM Declaration (Doc ID 2546284.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Trade Compliance Cloud Service - Version 19 and later
Oracle Trade Compliance - Version 6.4.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run 'Execute Compliance Rules' action on a GTM Declaration that includes two lines for the required documents determination, where the Compliance Rule has a Document Type and a Reviewer in the Controls, the following error occurs.

Debug Sql insert into gtm_trans_reqd_reviewer (gtm_transaction_gid,document_def_gid,contact_gid,domain_name,as_involved_party_qual_gid) values (?,?,?,?,?); 
[<Domain-Name>.D-20190523-000001, AES_FILING, <Domain-Name>.503023561, <Domain-Name>, null]
[<Domain-Name>.D-20190523-000001, AES_FILING, <Domain-Name>.503023561, <Domain-Name>, null]

Error Exception [56404713] Cannot add the GTM_TRANS_REQD_REVIEWER_T record. [GTM_TRANSACTION_GID, DOCUMENT_DEF_GID, CONTACT_GID] must be unique.

D-20190523-00000 is the GTM Declaration.

AES_FILING is the Document Type.

503023561 is the Reviewer.

Please note that GTM is trying to insert the two entries with the same reviewer.

Changes

 

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
Changes
Cause
Solution


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