How to compile the untranslated menus after implementing NLS

How to compile the untranslated menus after implementing NLS: 

1. Login to Applications as System Administrator, select "Security -> Responsibility -> Define", and query the Responsibility that has the problem

2. Locate the "Menu" field, and note the MENU_NAM.

3. Exit Define Responsibility form.

Invoke Define Menu form and then enter query.

Put the menu details identified in step 2 in the "User Menu Name" field and execute query. This will give menu name which could be used in step 4.

4. Run the following SQL:

select menu_name, menu_id from fnd_menus

where menu_name IN ('<MENU_NAMES identified with step 3>);

5. Once the MENU_ID's are located, run the following SQL:

set pages 100 col prompt format a30

select PROMPT,SOURCE_LANG from FND_MENU_ENTRIES_TL

where MENU_ID IN (<menu id's identified in step 4);

The values should return a SOURCE_LANG row for each installed language and their translated prompt Verify the untranslated prompts

6. Now having the MENU_NAME, locate the loader file tha delivers these definitions :

On UNIX session (assuming it's UNIX), run the following command :

cd $PRODUCT_TOP/patch/115/import/NLS (related to the Responsibility or MENU)

Then substitue the MENU_NAME below with those identified earlier

find ./ -name "*.*" -exec grep -Hsi 'menu in specific language' {} \;

7. Once the file(s) is (are) identified, check the content, and verify the translated prompts, and compare this file with the one supplied with the patch.

8. For those identified loader files from step 6, run the FNDLOAD command to load the above mentioned ldts manually .

The syntax for the fndload command is as below :

FNDLOAD apps/<Password> 0 Y UPLOAD $FND_TOP/patch/115/import/<filename>.lct $PRODUCT_TOP/patch/115/import/<NLS Directory>/<filename>.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=NLS WARNINGS=TRUE

9. To find the lct file for a specific ldt file, open the ldt file. It will contain the lct file name to use. Find the location of that lct in the system and use it in fndload command

10. Check whether the menus are appearing properly

+++++++++++++++++++++++++++

MOS ID 417340.1 , 393861.1 & 299080.1

+++++++++++++++++++++++++++