GTM Product Classification Code Auto Changing To Upper Case In Product Classification Code Search Field.

(Doc ID 1318680.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Global Trade Management - Version: 6.2.0 to 6.2.2 - Release: 6.2 to 6.2
Information in this document applies to any platform.

Symptoms


When attempting to search for specific Product Classification code, the value entered is changed to uppercase. The client is expecting the value to stay as entered as there is mixed case stored in the database for this field. Due to this issue, a valid result cannot be returned.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into OTM.
2. Go to Trade Master Data --> Power Data --> Product Classification --> Product Classification Code.
3. In the field Product Classification Code type in 5A002.a.4.
4. Click the TAB button.
5. Note 5A002.a.4 is changed to 5A002.A.4.
6. Because of this, valid results are not returned as they are inserted into the database with a lower case a.

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