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).

Latest posts by Brijesh Gogia (see all)

• Building a Scalable and Secure AI Infrastructure in the Cloud - May 12, 2024
• Harnessing the Power of AI in the Cloud for Business Transformation - March 2, 2024
• Building a Resilient Cybersecurity Framework in the Oracle Cloud - January 16, 2024