FNDLOAD usually downloads LDT file based on the application specific default language (most of the cases default language would be ‘US’). Some time we end up in situation to download LDT files for Lookups and Messages which are based on other languages like French, Japanese, etc.,. In such situations we need to set language information before downloading the LDT file.
Below is example of setting language for ‘French’
export NLS_LANG="French_France.WE8ISO8859P1"
FNDLOAD apps/<apps_password> O Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct <MSG_FILE_NAME>.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="<APPLICATION_SHORT_NAME>" MESSAGE_NAME="<MSG_NAME>" |
export NLS_LANG="French_France.WE8ISO8859P1"
FNDLOAD apps/<apps_password> O Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct <MSG_FILE_NAME>.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="<APPLICATION_SHORT_NAME>" MESSAGE_NAME="<MSG_NAME>"
Syntax to set NLS_LANG
export NLS_LANG=<NLS_LANGUAGE>_<NLS_TERRITORY>.<clients characterset> |
export NLS_LANG=<NLS_LANGUAGE>_<NLS_TERRITORY>.<clients characterset>
How to find out Language, Territory and Character set
SELECT nls_language,
nls_territory,
nls_codeset
FROM fnd_languages
WHERE nls_territory = 'FRANCE'
AND language_code = 'F'; |
SELECT nls_language,
nls_territory,
nls_codeset
FROM fnd_languages
WHERE nls_territory = 'FRANCE'
AND language_code = 'F';
How to find NLS_LANG configured in current session
SELECT parameter,
VALUE
FROM nls_database_parameters
WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY','NLS_CHARACTERSET'); |
SELECT parameter,
value
FROM nls_database_parameters
WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY','NLS_CHARACTERSET');