Oracle Application Language installation

1. Check if there is enough disk space on the  system Extra disk space is required for each additional  languages.

4   GB of disk space is require in $APPL_TOP for  each additional language 10 GB of disk space is required in oradata for each additional language 

2. Active the new Language(s) using Oracle  Applications Manager

Login to http://$mt_hostname.$domainname:$port_prefix15 as sysadmin 

Select Site Map -> System Configuration: Licence  Manager -> Languages

Select all the Languages that are in list

Select Next -> Submit

3. Maintain Multilingual Tables and  compile objects

Login to MT host 

Run adadmin

Select 4. Maintain Applications Database Entities

Select 3. Maintain Multi-Lingual Tables

Once this has completed use adadmin to  Maintain Snapshot information:- 

Select 7. Return  to Main Menu

Select 2. Maintain Applicatiosn Files Menu

Select 5. Maintain snapshot information

Select 2. Update current view snapshot (Note: This step can take a while - approximately 2 hours on a  test system)

Select 7. Return to Main Applications Files Menu

Select 7. Return to Main Menu

Select 3. Compile Reload Applications  Database Entities menu

Select 3. Compile flexfields

4. Manifest file for NLS

1 Generate the Manifest File

 Pre-req patch : 5635729 (for latest adgennls.pl file)

Login to $mt_hostname as ap$cust_id

perl $AD_TOP/bin/adgennls.pl

This generates a manifest file in the $APPL_TOP/admin/$TWO_TASK directory

This file contains all the active lanaguages.

2 Upload the Manifest

Copy this manifest file to your PC.

Login to https://updates.oracle.com/TransSync with you Metalink username and password.

Use the Request a New Patch button to upload the correct file and press Submit.

Note: Also choose 'Get Latest Translations'

You should  receive an email to your oracle email account once the NLS patch is available - it usually takes 7 - 8 hours.

Note: If you do not receive an email with the confirmation for a completed patch you may want to check https://updates.oracle.com/TransSync periodically - once the patch is available it should be listed on this page. The requested patch can be listed as 'In Progress',  'Merged Translation' or 'Full Translation' so please verify this before downloading it to the customer mid tier. Some patches can take up to 2 days for creation.

3 Download NLS Patch and apply.

Once the patch is available go back to https://updates.oracle.com/TransSync and you will see your patch.

If you can access updates.oracle.com directly from the server you can ftp the patch directly to the server (use your Metalink username and password).

If you cannot access updates.oracle.com  - click on the patch to download it to your PC then upload it to the server and apply.