Menus

When different functions are organized in a hierarchical fashion, it is called a menu. Menu is a component of oracle applications which is used for navigation purpose. A menu can be made of different functions or it can have sub-menus under it. A menu is a tree kind of structure, the lowest node being a function. Top menu is usually assigned to a responsibility. The following figure shows menu structure for GL Budget Super Menu:

A custom menu can also be created and assigned to a custom responsibility. When creating a new custom menu, one should start at the bottom, assigning functions to sub-menus and then finally assigning sub-menus and functions to a top menu.

The following screen is used for defining new menu:

The important fields in this screen are described below:

Menu:  Short Name of the Menu

User Menu Name: User defined name of the Menu

Menu Type:  Choose ‘Standard’

Description:  Description of the Menu.

The menu items appear in the sequence given. The sequence can be 1,2,3..or 10,20,30…etc. For each menu item, a prompt should be given if we want that menu item prompt to appear. Then we can either specify a Submenu or a Function. The sub-menu should have been already defined as a menu before using in the menu.

By Clicking ‘View Tree’ button, it is possible to see the menu in graphical format.

Technical Details of the Menu

A menu detail is stored in the following tables:

FND_MENUS: This table contains Menu Header information.

FND_MENU_ENTRIES: This table contains detail of all the entries in the menu. It contains columns Entry Sequence, Sub-Menu ID and Function ID.