FND Menus

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Lists all Oracle E-Business Suite menus (FND_MENUS) together with the number of responsibilities that reference each menu.

The Responsibility Count column shows the total number of responsibilities pointing at the menu; Active Responsibility Count excludes end-dated responsibilities.

Use the Assigned To Responsibility parameter to find the menu behind a specific responsibility, or Me ...  Lists all Oracle E-Business Suite menus (FND_MENUS) together with the number of responsibilities that reference each menu.

The Responsibility Count column shows the total number of responsibilities pointing at the menu; Active Responsibility Count excludes end-dated responsibilities.

Use the Assigned To Responsibility parameter to find the menu behind a specific responsibility, or Menus With Responsibilities Only to hide unused menus. Results are ordered by responsibility count so the most widely used menus appear first.   more 
select
fmv.user_menu_name,
fmv.menu_name,
xxen_util.meaning(fmv.type,'MENU_TYPE',0) menu_type,
fmv.description,
xxen_util.zero_to_null(x.responsibility_count) responsibility_count,
xxen_util.zero_to_null(x.active_responsibility_count) active_responsibility_count,
xxen_util.user_name(fmv.created_by) created_by,
xxen_util.client_time(fmv.creation_date) creation_date,
xxen_util.user_name(fmv.last_updated_by) last_updated_by,
xxen_util.client_time(fmv.last_update_date) last_update_date
from
fnd_menus_vl fmv,
(
select
fr.menu_id,
count(*) responsibility_count,
count(case when nvl(fr.end_date,sysdate)>=sysdate then 1 end) active_responsibility_count
from
fnd_responsibility fr
group by
fr.menu_id
) x
where
1=1 and
fmv.menu_id=x.menu_id(+)
order by
nvl(x.responsibility_count,0) desc,
fmv.user_menu_name
Parameter NameSQL textValidation
User Menu Name
fmv.user_menu_name=:user_menu_name
LOV
Menu Name
fmv.menu_name=:menu_name
LOV
Menu Type
fmv.type=:menu_type
LOV
Assigned To Responsibility
fmv.menu_id in (
select
frv.menu_id
from
fnd_responsibility_vl frv
where
frv.responsibility_name=:responsibility_name)
LOV
Menus With Responsibilities Only
x.responsibility_count is not null
LOV
Download
Related Blitz Reports
FND Responsibility Menu Exclusions FND Responsibility Access 11i FND Responsibility Access FND Responsibilities AP -SM Suppliers FND Menu Entry Upload FND Menu Entries COPY OF: CAC OPM Costed Formula XXFJ CST Inventory Value - Multi-Organization (Item Costs)
Blitz Report™