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
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
Very nice ...it saved me..good job bro
ReplyDeleteThank bro thats what am looking for.
ReplyDeleteEdit: 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
set the Arabic nls lang before uploading
ReplyDeleteYou cannot use FORCE mode to Arabic. If you do that, it will overwrite the English uploaded
ReplyDeleteIf database has character set as AR8MSWINCP1256 and Unix server is UTF8 - FNDLOAD downloads garbage characters. Any way to avoid it? Thanks
ReplyDelete