Unable to Create GTM Trade Item With Item Name More Than 50 Characters

(Doc ID 2380380.1)

Last updated on MARCH 29, 2018

Applies to:

Oracle Global Trade Management - Version 6.4.1 and later
Information in this document applies to any platform.

Symptoms

 You are not able to create a GTM Trade Item with Item Name that has more than 50 characters from UI even though the column length is 240 characters.

Go to Trade Master Data > Trade Item Management > Trade Item > New

Try to create a Trade Item with an ITEM NAME that contains more than 50 characters. GTM only takes 50 characters.

Looking at the DB schema at the ITEM table, the ITEM_NAME size is 240 characters.

ITEM_NAME VARCHAR2(240)

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