GTM Product Classification Code Auto Changing To Upper Case In Product Classification Code Search Field.
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms