Lightweight MLS in 12.1.3

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:

1. From Oracle Applications Manager, go to License Manager and activate the desired language.
2. From the AD Administration Main Menu, choose the ‘Maintain Applications Database Entities’ option and then the ‘Maintain Multi-lingual Tables’ task.
3. 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 11.2.0.2.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.

About these ads