My Oracle Support Banner

Sending XML Transmission To Update (IU) Tariff Classifications Creates Duplicates (Doc ID 2370512.1)

Last updated on AUGUST 05, 2024

Applies to:

Oracle Global Trade Management Cloud Service - Version 6.4.2 and later
Oracle Global Trade Management - Version 6.3.7 and later
Information in this document applies to any platform.

Symptoms

A transmission that is sending updates for two items is creating duplicate rows for one of the items in the GTM_ITEM_CLASSIFICATION table. 

Why is the transmission creating duplicate rows for one item, but not the other item? You get a duplicate tariff code for HTS US. The chapter 98 code is not updated, and instead a new non-chapter 98 classification is added for HTS US.

You can see there is one HTS US code for each item before the transmission is sent.

In each case for each of the duplicates you are trying to update with a non-chapter 98 tariff code, but instead of updating, it gets duplicated. The Chapter 98 tariff code remains.

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.