Oracle EBS R12: Extract a Complete Menu, its Functions and Sub-Menus via SQL

The following query will extract all the functions, Sub-Menus & the functions & sub-menus within the above sub-menus on a single sheet.

Creating restricted responsibilities for users may require condensed Menus with fewer functions & sub-menus. Creating such menus can become very hectic by navigating in and out of the seeded menus to pick the right functions and sub-menus to include.

Continue reading


Oracle EBS R12: Extract your complete Quality Plan Setup via SQL

The following query can be used to extract the complete setup of your quality plan. It starts extracting your setup form the plan and goes back to the elements attached to the plan.

Continue reading