How to upload translated program definitions(multilingual) using FNDLOAD command

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

To download an Oracle application definition(eg:- concurrent program), we need to export the NLS_LANG variable, then run the fndload command when we need to download a specific language. 

Note:- The NLS_LANG parameter has three components (language, territory, and charset) in the form:

         NLS_LANG = language_territory.charset

The environment variable NLS_LANG must be set at operating system level. To check the current value:

$ env | grep NLS_LANG

should return a value such as:

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

If this is not set, do the following:

$ NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
$ export NLS_LANG

Run the download command:

FNDLOAD apps/pwd@seeddb 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct  

file_name.ldt PROGRAM APPLICATION_SHORT_NAME=”prod” CONCURRENT_PROGRAM_NAME=”concurrent name” 

---------------------------------------------------------------------------------------------------------------------
for US (American) use export NLS_LANG="AMERICAN_AMERICA.US7ASCII"
---------------------------------------------------------------------------------------------------------------------
for HU (Hungarian) use export NLS_LANG="HUNGARIAN_HUNGARY.EE8ISO8859P2"
---------------------------------------------------------------------------------------------------------------------
for ES (Spain) use export NLS_LANG="SPANISH_SPAIN.WE8ISO8859P1"
---------------------------------------------------------------------------------------------------------------------
for DE (German) use export NLS_LANG="GERMAN_GERMANY.WE8ISO8859P1"
---------------------------------------------------------------------------------------------------------------------
for JA(Japan) use export NLS_LANG = JAPANESE_JAPAN.JA16EUC
---------------------------------------------------------------------------------------------------------------------

Run the following FNDLOAD command to UPLOAD translated concurrent program definition:

 

$FND_TOP/bin/FNDLOAD apps/password@seeddb 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct file_name.ldt - - UPLOAD_MODE=NLS WARNINGS=TRUE

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