FND Menus – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports

Overview

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.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

User Menu Name, Menu Name, Menu Type, Assigned To Responsibility, Menus With Responsibilities Only

Oracle EBS Tables Used

fnd_menus_vl, fnd_responsibility

Report Categories

Enginatics

FND Responsibility Menu Exclusions, FND Responsibility Upload, Blitz Report Template Sharing, FND Responsibility Access, FND Responsibilities, FND Menu Entry Upload, FND Menu Entries

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import FND_Menus.xml
SQL Source FND Menus.sql
Full Report on Enginatics www.enginatics.com/reports/fnd-menus/

Case Study & Technical Analysis: FND Menus

Executive Summary

FND Menus lists every Oracle E-Business Suite menu from the Application Object Library, with its type, its description, the number of responsibilities that reference it and the number of those responsibilities that are still active. It is written for EBS security administrators, functional leads and technical consultants who need to understand which navigation menus are in use, which menu sits behind a responsibility, and which menus can be retired. The output supports menu rationalization projects and access reviews before a responsibility is changed.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. The responsibilities are summarized in an inline view that groups FND_RESPONSIBILITY by menu identifier.
  2. Within that view, one count returns all responsibilities and a second count returns those whose end date is empty or later than the current date.
  3. The inline view is outer joined to FND_MENUS_VL on the menu identifier, so menus with no responsibilities are kept.
  4. The menu type, creator and last updater are resolved through the Blitz Report™ meaning, user name and client time functions.
  5. Rows are ordered by the responsibility count in descending order, then by user menu name.

Parameters & Filtering

Performance & Optimization

FAQ

Q: How do I find the menu behind a responsibility? A: Enter the responsibility name in the Assigned To Responsibility parameter. The matching menu is returned with its counts.

Q: What is the difference between Responsibility Count and Active Responsibility Count? A: Responsibility Count includes every responsibility that references the menu. Active Responsibility Count excludes responsibilities whose end date has passed.

Q: How can I list only menus that are in use? A: Set Menus With Responsibilities Only to Yes, and only menus referenced by at least one responsibility are returned.

© Enginatics GmbH