Need To Know Whether An ATC Class Name Can Be up to 110 Characters Long In TMS 4.5.2 (Doc ID 1461449.1)

Last updated on DECEMBER 04, 2019

Applies to:

Goal

TMS 4.5.2

Need to know whether an ATC Class name can be up to 110 characters long in TMS 4.5.2

The names of ATC classes in WHO Drug Dictionary are sometimes too long.

Thus up to the September 2011 release of the WHODD, the names were truncated in the file (INA file) which contains the ATC terms.

But, in the March 2012 release, the Upsala Monitoring Centre has made available a file named INA_LongText for the B-format WHODD users.

The said file contains the full-length names (up to 110 characters) of the ATC classes.

We need to know whether the Text Filed in TMS (4.5.2) would support a 110 character long name.

There are 50 character long names already present in the old version of WHODD in our system.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.