AnsweredAssumed Answered

How to disable multilingual support for CA PPM or cleanup CMN_CAPTIONS_NLS table?

Question asked by Georgy N Joseph on Apr 24, 2017
Latest reply on Oct 19, 2018 by David_Marchal_CoPrime

Hi Friends,


Is there any supported way to disable multilingual support for CA PPM tool in case we just need only English language? 


For example, when we look at our CMN_CAPTIONS_NLS table, out of the 20498951 total number of records only 1033114 are the ones with language_code='en' which is just about 5% of the total number of records in this table. If we are sure that we don't want to see any other language in the CA PPM tool, is it safe to cleanup the CMN_CAPTIONS_NLS table by issuing the below command (ofcourse in many delete batches) ?


delete from CMN_CAPTIONS_NLS where language_code<>'en' 


Will this cleanup break any CA PPM stock/custom functionality like XOG? Has anyone tried this before? And what can we do to stop further generation of Non-English records in the CMN_CAPTIONS_NLS table even after the above one-time cleanup? Any suggestions/warnings/ideas?