FND Menu Entry Upload

➜ Back to Library
Description
Categories: Enginatics, Upload
Repository: Github
Upload to create, update and delete menu entries in FND Menus.
Useful for adding entries to existing menus, e.g. during Supply Chain Hub installation.

Upload Modes
============

Create
------
Opens an empty spreadsheet where the user can enter new menu entries.

Create, Update
--------------
Downloads existing menu entries matching the Menu Name filter for revi ...  Upload to create, update and delete menu entries in FND Menus.
Useful for adding entries to existing menus, e.g. during Supply Chain Hub installation.

Upload Modes
============

Create
------
Opens an empty spreadsheet where the user can enter new menu entries.

Create, Update
--------------
Downloads existing menu entries matching the Menu Name filter for review and update.
New rows can be added to create additional entries in the same upload.

Fields
======
- User Menu Name: Display-only. Shows the translatable menu name.
- Menu Name: Required. The internal menu name (e.g. INV_NAVIGATE).
- Entry Sequence: The sequence number for the entry within the menu. Auto-assigned if not provided for new entries.
- Prompt: The display text shown in the menu for this entry.
- Entry Description: Optional description of the menu entry.
- Sub Menu: The sub-menu to navigate to. Either Sub Menu or Function Name must be specified.
- Function Name: The form function to launch. Either Sub Menu or Function Name must be specified.
- Grant Flag: Y (default) = entry is grantable via security, N = not grantable.
- Delete Record: Set to Y to delete an existing menu entry.   more 
select
null action_,
null status_,
null message_,
null request_id_,
null modified_columns_,
fmv.user_menu_name,
fmv.menu_name,
fmv.description menu_description,
xxen_util.meaning(fmv.type,'MENU_TYPE',0) type,
fme.entry_sequence,
fmet.prompt,
fmv2.user_menu_name sub_menu,
fffv.user_function_name function_name,
fmet.description entry_description,
xxen_util.meaning(fme.grant_flag,'YES_NO',0) grant_flag,
to_char(null) delete_record
from
fnd_menus_vl fmv,
fnd_menu_entries fme,
fnd_menu_entries_tl fmet,
fnd_menus_vl fmv2,
fnd_form_functions_vl fffv
where
1=1 and
fmv.menu_id=fme.menu_id and
fme.menu_id=fmet.menu_id and
fme.entry_sequence=fmet.entry_sequence and
fmet.language=userenv('lang') and
fme.sub_menu_id=fmv2.menu_id(+) and
fme.function_id=fffv.function_id(+)
Parameter NameSQL textValidation
Upload Mode
:p_upload_mode like '%' || xxen_upload.action_update
LOV
User Menu Name
fmv.user_menu_name=:user_menu_name
LOV
Menu Name
fmv.menu_name=:menu_name
LOV
Function Name
fffv.function_name=:function_name
LOV
User Function Name
fffv.user_function_name=:user_function_name
LOV
Responsibility
exists (select null from fnd_responsibility_vl frv where frv.menu_id=fmv.menu_id and frv.responsibility_name=:responsibility_name)
LOV
Download
Related Blitz Reports
FND Responsibility Access 11i FND Menu Entries FND Responsibility Access FND User Login Page Favorites FND Responsibility Menu Exclusions Mrugesh test report Blitz Report Assignments and Responsibilities FND Forms Personalizations FND W3H_Role_Functions
Blitz Report™