We had a requirement where we need to store our item’s descriptions in 5 different languages in all the countries that we are doing business with. This is only needed for some reporting purposes. There was no need for boilerplates in these languages. The forms and self service pages doesn’t need to be in any other language other than English.
The tasks of maintaining five different languages for these languages is daunting. Thankfully, in 12.1.3 we came across this new feature “Lightweight MLS”.
Lightweight MLS exactly addresses the problem that I explained above. It enables additional languages without the need to apply an NLS patch.
We enable MLS as follows:
- From Oracle Applications Manager, go to License Manager and activate the desired language.
- From the AD Administration Main Menu, choose the ‘Maintain Applications Database Entities’ option and then the ‘Maintain Multi-lingual Tables’ task.
- Run the message synchronization script $FND_TOP/patch/115/sql/AFMSGSYNC.sql
$ sqlplus apps/apps @AFMSGSYNC.sql SQL*Plus: Release 10.1.0.5.0 - Production on Thu Apr 5 10:11:52 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options NOTE: This script synchronizes the language data in FND_NEW_MESSAGES table with the base language data. Press RETURN to continue. Currently, following languages are installed: CODE NAME STATUS ---- ------------------------ ------------ US American English Base D German Install FRC Canadian French Install Please choose Oracle Language code from the installed languages. For example JA for Japanese. This language data will be synchronized with the base language data. Language Code: D You chose Spanish (D). Is this correct language to synchronize [Yes] ? Reading FND_NEW_MESSAGES table to see if language data exists. No Spanish language data exists in FND_NEW_MESSAGES table. Base language data will be copied to this language. Do you wish to proceed [No] ? Yes Synchronization is in progress... Synchronization has been done. Please do a 'commit' if changes are OK. Otherwise, do a 'rollback'. SQL> commit; Commit complete. Shut down and restart the application tier services. Now we have Lightweight MLS enabled.