Translation Synchronization patches or Addition of Patches

Reference Note id's:
********************
R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)
Oracle Applications NLS Release Notes, Release 12.1 (Doc ID 788053.1)
How To Apply An NLS Patch Again When The Maintain MultiLingual Step Is Missed (Doc ID 1623652.1)

1.Shutdown required MT and DB services
2.Take  required backup
3.Start the DB and MT services.
4.Install the required Language (French) from OAM.

Enabling the Arabic from OAM, folllow the below steps
Login to OAM as a sysadmin -> sitemap -> License Manager -> License -> Languages And license the following language

Enable the below languages

a. Spanish
b. Korean
c. Simplified Chinese
d. Traditional Chinese 

Note:Make sure you should not change the base language, it should be english.

5.Validate the language activated

Login to application with apps user and execute the below command.

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

Make sure you get below result.

a. Spanish
b. Korean
c. Simplified Chinese
d. Traditional Chinese 

Here base lang is American

5. Stop MT services
6.Run Maintain Multi-lingual Tables

      4.Maintain Applications Database Entities
              
         3. Maintain multi-lingual tables

AD Administration Main Menu > Maintain Applications Database Entities Menu using adadmin.

7.Run Update current view snapshot from adadmin

adadmin -> Maintain Applications Files -> Maintain snapshot information -> Update current view snapshot)

             2.    Maintain Applications Files menu

                4.    Maintain snapshot information

                   2.    Update current view snapshot

                      1.    Update Complete APPL_TOP

8.Run the Translation Synchronization Patch utility (adgennls.pl)

Login to applmgr user in application tier, make sure enviorment is sourced properly and execute the following command

perl $AD_TOP/bin/adgennls.pl

Above command will genertate the manifest file which you need to upload to support. Menifist file will be on following location:

$APPL_TOP/admin/$TWO_TASK/out/adgennls.txt

9.Upload the manifest file to oracle support, use the below steps.

Upload the adgennls.txt file to https://updates.oracle.com/TransSync.
Once you upload the file, select the option Get Latest Translstions and click on next it will provide you the patch number which support is going to generate for NLS syncronization.

Note:If you do not receive any email regarding your request within 48 hours, you may contact Oracle Support for assistance.
this patch will generate NLS media patck, it will take some time to generate

15.Bring up the instance and release instance to customer
16.Once we have TSP patches then apply the Translation Synchronization patches with options=nocheckfile. 

adpatch  driver=u_merged.drv -options=nocheckfile

10.Bring down DB and MT services and take one cold backup
11.Start DB and listener.
12.Follow the instructions in the README file to apply the patch.

note: Before Applying patch make sure enough space in appl top directory, patch initially copy all required files to appl top create new lang patch Choose a directory that contains enough space for the NLS updates (about 10 GB for each language Minimum).

unzip patches in source folder
mkdir /home/applmgr/patch/dest
chmod -Rf 777 /home/applmgr/patch/dest
admrgpch -s /home/applmgr/patch/source -d /home/applmgr/patch/dest -merge_name u_mergeded
cd /home/applmgr/patch/dest
adpatch driver=u_mergeded.drv options=nocheckfile

13.AD Administration utility to generate message files from the Generate Applications Files menu.
14.Compile the invalid objects using utlrp.
15.Complie Forms and Reports
16.Complile Apps schema and validate apps schema
17.Check below queries it has to show other languages also:
SQL> select RESPONSIBILITY_ID,RESPONSIBILITY_Name,LANGUAGE,SOURCE_LANG from fnd_responsibility_tl where RESPONSIBILITY_ID in ('20419','20420');

RESPONSIBILITY_ID RESPONSIBILITY_NAME            LANG  SOUR
----------------- ------------------------------                      ----    ------
            20419 Application Developer                        US       US
            20420 System Administrator                        US       US
            20419 Desarrollador de Aplicaciones           ESA     ESA
            20420 Administrador de Sistema                 ESA     ESA
            
18.Bring up the applications services