How to Install new language [French] on R12.1.1 Oracle EBusiness Suite

How to Install new language [French] on R12.1.1 Oracle EBusiness Suite

The documents I followed ->

How to resolve NLS translation issues in an Ebusiness Suite 11i and R12 environment [ID 394112.1]

How To Get The Guidelines To Install or Add the new NLS Language on E-Business Suite 11i or R12 [ID 1254325.1]

Oracle Applications NLS Release Notes Release 12 [ID 405294.1]

Requesting Translation Synchronization Patches [ID 252422.1]

Step 1. Activate new language using OAM License Manager
If your database does not have unicode character set [like UTF8] this option will be disable. Then follow the following page to convert the database character set first.

http://www.oracle-latest-technology.com/2011/02/how-to-convert-character-set-of-oracle.html

Step 2. Run adadmin to maintain multilingual tables

Go to adadmin > Maintain multi-lingual tables >

Step 3. Follow Oracle Applications NLS Release Notes, Release 12.1 [ID 788053.1] .

If needed apply patch 8576725. download language patch [6678700 for R12.1] from http://edelivery.oracle.com/ and install it.

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

Issue faced ->

During application of the NLS patch 6678700 for french language, I am getting the following error ->

The current description will not be changed.

Patch 6678700:F is a NLS patch.

You must first apply the corresponding US patch

for the NLS patch(es) listed above.

AutoPatch error:

--------

A fatal error related to codelines or codelevels has occurred.

I have done the following things before applying this patch ->

1. Activate new language using OAM License Manager
2. Run adadmin to maintain multilingual tables

3. Followed all the prerequisites mentioned in the doc Oracle Applications NLS Release Notes, Release 12.1 [ID 788053.1] . Applied patch 8576725.

Solution ->

We don't need to apply 6678700 as the language is already active.

check it using the following command ->

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

See the following discussion if you want to know more details->

http://forums.oracle.com/forums/message.jspa?messageID=9389446#9389446

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

Step 4. Follow this document Requesting Translation Synchronization Patches [ID 252422.1].

Create Manifest file. Upload it to oracle site. They will provide the patch set 11803377.

Apply patch set 11803377.

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

Isuue faced ->

Failed worker ->

1 Run AutoPatch R120 bomprg.ldt FAILED

2 Run AutoPatch R120 payzzcncprg00514.ldt FAILED

3 Run AutoPatch R120 jg12acp.ldt FAILED

4 Run AutoPatch R120 amscitem.ldt FAILED

Checked the worker log file. The error is coming due to following error.

ORA-24816: Donnees bind non LONG developpees fournies apres colonne LONG ou LOB

English translation -> ORA-24816: Data not bind LONG developed provide after LONG or LOB column

Solution ->

Check metalik doc ID 452095.1.

Basically need to change Solaris env variable $NLS_LANG as in database.

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

Step 5. After adding the patch 11803377 restart the application tier using ./adstpal.sh and ./adstrtal.sh.

You can select your new language in the login screen.