FNDLOAD for Multilingual/Territory

By | May 26, 2014

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:
  • swapnil jain

    Hi, When I am using FNDLOAD command:

    FNDLOAD apps/apps@xxxxxx 0 Y DOWNLOAD @FND:patch/115/import/afcpprog.lct ap12acp.ldt PROGRAM APPLICATION_SHORT_NAME=SQLAP I am getting below error:

    Message Dictionary couldn’t open the FND message file for
    language US. Cannot open file /fnddev/fnd/FND0122/mesg/US.msb for
    reading.

    Please help.

    • Hello Swapnil,

      Looks like you are trying to download an LDT file for a concurrent program but the program short name is not mentioned in the command. Please refer to below syntax:

      FNDLOAD apps/${PASSWD} 0 Y DOWNLOAD @fnd:patch/115/import/afcpprog.lct ${CONC_PROG_NAME}.ldt PROGRAM CONCURRENT_PROGRAM_NAME=${CONC_PROG_NAME} APPLICATION_SHORT_NAME=${APPL}

      For more information on FND LOAD see this post: http://oracleappsdna.com/2011/06/fndload-utility-to-port-reports-from-one-environment-to-another/

      Thanks,
      Shailender

      • swapnil

        Hi Shaiender,
        Thanks for replying!!
        This time i also mentioned concurrent program name but getting same error msg.

        –swapnil

        • swapnil

          Hi .. got the issue.
          Actually mesg folder is not present on the instance.

          Thanks