Menu Creation in Oracle APPS

   You can follow the below steps to create menu in Oracle Apps

1) Go to Application Developer/System Administrator Responsibility=>Application=>Menu

Menu window will be opened

2) Enter the Menu field.
3) Enter the user Menu Name. This name will be displayed at front end.
4) Menu Type is optional field.
5) Enter the description.
6) Go to detail block to attach the form function/submenu.
7) Enter the sequence number.
8) Enter the prompt . This is the name which shows at front end for the form/submenu.
9) Go to function field and select which form function you need to attach to the menu from the LOV.
10) You can also select/attach the submenu to your menu. Submenu is also a menu which may have list of form functions and submenus.
11) Click on save.
12) It will submit a request to recompile the menu in the database.

13) For confirmation Open menu press F11 . Enter the menu name and press ctrl+F11.

14) You can check the menu details from the database 

 FND_MENUS displays the menu information . Using the menu_id you can trace from other menu related tables.
SELECT * FROM FND_MENUS WHERE menu_name ='XXCUSTOM_TEST_MENU'

 FND_MENUS_TL displays user menu name information and language
SELECT * FROM FND_MENUS_TL WHERE menu_id=1024482

   Form Function and submenu information are available in FND_MENU_ENTRIES table. Using SUB_MENU_ID and FUNCTION_ID you can trace it further.
SELECT * FROM FND_MENU_ENTRIES where menu_id=1024482