Listing responsibility-menu-submenu-function in Oracle EBS

The below scripts can be used for responsibility, menu, submenu, and function details of specific responsibilities.

1. Retrieve a list of all responsibilities.
Parameters: None

SELECT
(SELECT application_short_name
FROM fnd_application fa
WHERE fa.application_id = frt.application_id)
application
, frt.responsibility_id
, frt.responsibility_name
FROM apps.fnd_responsibility_tl frt
--where responsibility_name like '%responsibltiy_name%';

2. Menus Listing
Purpose/Description: To see the Menus associated with a given responsibility
Parameters: responsibility_id from query#1 above

SELECT DISTINCT
a.responsibility_name
, c.user_menu_name
FROM
apps.fnd_responsibility_tl a
, apps.fnd_responsibility b
, apps.fnd_menus_tl c
, apps.fnd_menus d
, apps.fnd_application_tl e
, apps.fnd_application f
WHERE
a.responsibility_id(+) = b.responsibility_id
AND a.responsibility_id = <PUT_RESPONSIBILTIY_ID>
AND b.menu_id = c.menu_id
AND b.menu_id = d.menu_id
AND e.application_id = f.application_id
AND f.application_id = b.application_id
AND a.LANGUAGE = 'US';

3. Submenu And Function Listing
Purpose/Description: To can check function and submenus attached to a specific menu
Parameters : User_menu_name from query#2

SELECT
c.prompt
, c.description
FROM
apps.fnd_menus_tl a
, fnd_menu_entries_tl c
WHERE
a.menu_id = c.menu_id
AND a.user_menu_name = '<MENU_NAME>';

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

Listing responsibility-menu-submenu-function in Oracle EBS

Related posts: