Sunday, January 11, 2009

Add Arabic Language with Oracle Applications 11i (11.5.10.2)

Purpose of this Document


Oracle E-Business Suite Release 11.5.10.2 has been installed with English as the base language in the DEMO environment. The purpose of this document is to record details of adding Arabic Language to a single node installation for the DEMO environment.

To install a new language in an existing system, regardless of whether it is a newly created Release 11.5.10.2 system or an existing system you have just upgraded to 11.5.10.2, you must apply each language using the language software and AutoPatch.



Arabic Language Install Tasks:

1. Add the Arabic Language using OAM as follows.
OAM-> license manager->language->add language to Arabic.
2. Update multilingual tables.
To update all multilingual tables in your system, go to the AD Administration main menu, and choose the Maintain Applications Database Entities submenu. Then, run the Maintain Multi-lingual Tables task.
3. Create Language Patch Area.
• Choose a directory that contains enough space for the NLS updates (about 10 GB for each language).
• Create a subdirectory called nls11i10 in this directory. This subdirectory is the .
• Mount the NLS DVD software or copy the NLS DVD to a permanent file system. This is the .
• Populate the as follows:
$ cd /Disk1/nls/stage
$ ./adcrptop.sh \ /Disk1/nls/stage
For Example:
$ cd /mnt/Disk1/nls/stage $ ./adcrptop.sh /d1/oracle/patch/nls11i10 /mnt/Disk1/nls/stage

4. Install the translations using adpatch.
Each language directory in the patch area you created in the above step will contain two drivers:
u11510nls.drv – for a newly created Rapid Install 11.5.10.2 system
u11510upgnls.drv – for all other systems, including any type of upgrade
Run AutoPatch and specify the appropriate driver.

Post Install Tasks:
1. Install font files.
Download the font files. If you are using Oracle Applications11i.7(11.5.7) or higher you already have the Unicode font files in the Applications /resource directory and can proceed to the next step to complete installation of the files.


2. Copy the Fonts to the HTTP Server JDK
Copy the font files to the Java default font directory for the external JDK on the HTTP Server node where external JDK refers to the JDK (eg JDK 1.3.1) installation on the HTTP Server. You will need approximately 75MBytes of available space in the JDK font directory for the font files. As the owner of the external JDK files, use the following commands to copy the files:
cp /resource/ALBAN*.ttf /jre/lib/fonts

3. Remove Image Files from Cache Directory
The dynamically created images are cached in the /cabo/images/cache/ directory where is the language name in locale naming convention such as 'en' for English, 'ar' for Arabic
Remove all existing non-English language image files from the image cache directory. The file extensions of the cached images are '.gif' and '.imx'.
$ cd $OA_HTML/cabo/images/cache $ cd $ rm *.gif *.imx .
Restart the Apache Service
$ cd /admin/scripts/ $ adapcctl.sh stop $ adapcctl.sh start