Tax And Duty Analysis Screen Is Not Working After Country Code Conversion From 3 Digits To 2 Digits (Doc ID 1958703.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Global Trade Management - Version 6.3.3 to 6.3.6 [Release 6.3]
Information in this document applies to any platform.

Symptoms

Script convert_cc3_cc2.sql was run so that 2 character country codes could be used.
Post running this, when going to Trade Master Data -> Product Classification -> Duty and Tax Analysis and performing a match on Product classification code, the following error is seen:

ERROR
-----------------------
Either Product Classification Type does not have Country Associated
or The Associated Country does not have 2 digit country code.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Goto Trade Master Data -> Product Classification -> Duty and Tax Analysis
2. Select Product Classification Type, Product Classification Code, Ship from Country
3. Click on Match,

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