FNDLOAD for Multilingual/Territory

By | May 26, 2014 | 2,237 views | Category: AOL and SYSADMIN Tags: ,

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>"

Syntax to set NLS_LANG

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';

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');
WOW! Did you like this post? We'll send more interesting posts like FNDLOAD for Multilingual/Territory to you!
Enter your Email Address: