Adding and Maintaining NLS Languages

Adding and Maintaining NLS Languages

* This is the new requirement from our client of Installing Arabic language in our EBS R12.1.3 as a part of HRMS implementation.

I will be giving high level steps here along with the issues faced during this installation of new language.

Step 1. Activate the language

* Check the languages that are already installed in system.

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

Flag: 
B - Basic
I - Installed

* SO we have only US(American) language installed in our system as basic language, & now need to install Arabic language in addition with below steps.

Login to EBS with System Administrator Responsibility and follow below steps:

Navigation: System Administrator -> License Manager -> Languages-> 

* Check that new languages is in installed status in system.

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

LANG     NLS_LANGUAGE                      I

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

US           AMERICAN                              B

AR          ARABIC                                     I

SQL>

Step 2:Run Maintain Multi-lingual tables (MMT)

* Run adadmin and choose below options

     

 * Issues faced during MMT are mentioned at the end of the document.

Step 3.  Run Maintain snapshot information

* Run adadmin and choose below options

* end message will be like below:

1 Step 4.  Run Translation Synchronization Patch utility & Request Translation Synchronization Patches

* Run the Translation Synchronization Patch utility (adgennls.pl), upload the generated manifest to support and Requested Translation Synchronization Patches as per note 252422.1: 

* Upload this file at https://updates.oracle.com/TransSync and wait for patches from oracle.