Skip to content

FND Menu Entries

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

FND Menu Entries

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
FND Menu Entries.sql
FND Menu Entries.sql
 
 
README.md
README.md
 
 

README.md

layout default
title FND Menu Entries | Oracle EBS SQL Report
description – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Menu, Entries, fnd_menus_vl, fnd_menu_entries_vl, fnd_menus_tl
permalink /FND%20Menu%20Entries/

FND Menu Entries – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

None

Report Parameters

User Menu Name, User Menu Name like, Menu Name, Prompt, Submenu, Menu Entry, User Function Name, Function Name, User Form Name, Form Name, Assigned To Responsibility, Created By, Creation Date From, Creation Date To, Last Update Date From, Last Update Date To

Oracle EBS Tables Used

fnd_menus_vl, fnd_menu_entries_vl, fnd_menus_tl, fnd_form_functions_vl, fnd_form_vl

Report Categories

Enginatics

Related Reports

FND Menu Entry Upload, FND Responsibility Access 11i, FND Responsibility Access, FND Responsibility Menu Exclusions, FND User Login Page Favorites, Blitz Report Assignments and Responsibilities, FND Forms Personalizations, FND Responsibilities

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output FND Menu Entries 21-Jul-2017 172713.xlsx
Blitz Report™ XML Import FND_Menu_Entries.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-menu-entries/

Executive Summary

The FND Menu Entries report documents the menu hierarchy in Oracle EBS. It shows which functions and sub-menus are attached to a parent menu, effectively mapping out the navigation structure.

Business Challenge

  • Security Audit: Verifying which functions are accessible from a specific Responsibility's menu.
  • Navigation Design: Documenting the current menu structure before redesigning the user navigation.
  • Troubleshooting: Finding where a specific function (e.g., "Enter Journals") is located in the menu tree.

The Solution

This Blitz Report explodes the menu structure:

  • Menu: The parent menu name.
  • Entry: The prompt (label) seen by the user.
  • Function/Submenu: The actual function or child menu attached to that entry.
  • Grant: Shows if the function is "Grant" only (not visible, but authorized).

Technical Architecture

The report queries FND_MENUS_VL and FND_MENU_ENTRIES_VL. It can recursively traverse the tree if needed, but typically shows direct assignments.

Parameters & Filtering

  • User Menu Name: Filter by the top-level menu (e.g., "GL_SUPERUSER").
  • Function Name: Find all menus that contain a specific function.
  • Prompt: Search by the user-visible label.

Performance & Optimization

  • Recursion: Menu structures can be deep. The report is optimized to show direct relationships.

FAQ

  • Q: Does this show Exclusions?
    • A: No, this shows the definition of the menu. To see what a user can actually access (net of exclusions), use the "FND Responsibility Access" report.

Useful Links

© 2026 Enginatics