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
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
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.
No comments :
Post a Comment