Adding a new NLS language in EBS


Example New Language: Simplified Chinese

Adding languages after the implementation is complete may require a change in character set, unless UTF8 or AL32UTF8 was chosen

Languages in the same language category can be supported in a single instance using either Unicode (UTF8 or AL32UTF8) or the character set listed with the category. Languages from different language categories in a single instance can only be supported using Unicode. For example, since German is in the Western European language category and Polish is in the Eastern European category, only Unicode can support both German and Polish. However, English data is supported in any language category, because English characters are included in all of the other character sets.

Language is translated in Forms (F), Reports (R), and UIX (U).

1.      Check the Character set whether new language you are enabling is supporing or not? Refer Note Note 393861.1



SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET';

VALUE

--------------------------------------------------------------------------------

UTF8



2.      Activate new language from License Manager from Oracle Application Manager


Deactivating a language is not supported. Even if you are not using them, once activated, you must maintain all languages that are active in an NLS system


3.  Check from the tables, new language is activated or not?

SQL> select NLS_LANGUAGE from FND_LANGUAGES where INSTALLED_FLAG in ('B','I');

NLS_LANGUAGE

------------------------------

AMERICAN
SIMPLIFIED CHINESE

2 rows selected.

4. Run Maintain Multi-lingual Tables from Adadmin

Select Option 4.
Select option 3

5. Run Maintain Snapshot information from Adadmin


Select Option 4


6. Run the Translation Synchronization Patch utility (adgennls.pl) using below command

 perl $AD_TOP/bin/adgennls.pl

 The manifest generated from the tool is located at : $APPL_TOP/admin/$TWO_TASK/out/adgennls.txt

7. After you generate your manifest, you can go to https://updates.oracle.com/TransSync 

(use your My Oracle Support username and password).


   Follow the instructions on the screen to upload the manifest file. A Translation synchronization patch will be generated specifically based    on your manifest for each of your active language. The patch will synchronize the language file versions and American English file versions    in your Applications instance.


8. Install the Release 12 NLS Help for the new language (optional)
9. Generate message files from adadmin



Known issues
-------------

+ Performance Issue with Maintain Multilingual Tables EGONLINS.sql And INVNLINS.sql Taking Long Time (Doc ID 1391050.1)
+ Performance Issues Using Maintain Multi-Lingual Table, INVNLINS.SQL (Doc ID 981868.1)
+ Bug 12922572 : WHEN RUNNING MAINTAIN MULTILINGUAL TABLES, EGONLINS AND INVNLINS TAKE MORE 24 HR

References:
===========

How To Add A New Or Maintain A Language In R12 (Doc ID 1511692.1)

NLS Frequently Asked Questions (Doc ID 399789.1)
Globalization Guide for Oracle Applications Release 12 (Doc ID 393861.1)
Oracle Applications NLS Release Notes, Release 12.1 (Doc ID 788053.1)
Oracle E-Business Suite Maintenance Procedures. See the Adding and Maintaining NLS Languages section in Chapter 1
Requesting Translation Synchronization Patches (Doc ID 252422.1)