Wednesday, December 23, 2015

FNDLOAD for multi-language OR Multilingual

Some time we are facing situation where we have to move AOL objects in Oracle EBS Multilingual/Territory environment.
For example we want to move Lookups, Concurrent Programs, Messages etc with their translation also for Multilingual/Territory like English and Arabic.

In such scenario we have to download and upload LDTs for both languages.
Lets suppose we have to move Concurrent Program with both English and Arabic translations.

==============
DOWNLOAD
==============
Before downloading we have to set the export language style like,

For English           
-------------------------------------------------------------------------------
export NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXTST_CONCURRENT_PRG_US.ldt PROGRAM APPLICATION_SHORT_NAME="XXTST" CONCURRENT_PROGRAM_NAME="XXTST_CONCURRENT_PRG"

For Arabic           
-------------------------------------------------------------------------------
export NLS_LANG=ARABIC_AMERICA.AR8MSWIN1256

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXTST_CONCURRENT_PRG_AR.ldt PROGRAM APPLICATION_SHORT_NAME="XXTST" CONCURRENT_PROGRAM_NAME="XXTST_CONCURRENT_PRG"

==============
UPLOAD
==============
Similarly for Upload LDTs we have to set the language style.

For English           
-------------------------------------------------------------------------------
set NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXTST_CONCURRENT_PRG_US.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE


For Arabic           
-------------------------------------------------------------------------------
set NLS_LANG=ARABIC_AMERICA.AR8MSWIN1256

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXTST_CONCURRENT_PRG_AR.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE



5 comments:

  1. Very nice ...it saved me..good job bro

    ReplyDelete
  2. Thank bro thats what am looking for.

    Edit: when downloading Arabic it's all good, but when I upload it in arabic it's corrupted Arabic letters with square character. Any idea why?

    Thanks in advance

    ReplyDelete
  3. set the Arabic nls lang before uploading

    ReplyDelete
  4. You cannot use FORCE mode to Arabic. If you do that, it will overwrite the English uploaded

    ReplyDelete
  5. If database has character set as AR8MSWINCP1256 and Unix server is UTF8 - FNDLOAD downloads garbage characters. Any way to avoid it? Thanks

    ReplyDelete