FND User Login Page Favorites – Oracle EBS SQL Report

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

Overview

User’s HTML favourites from table icx_custom_menu_entries

Report Parameters

User Name

Oracle EBS Tables Used

icx_custom_menu_entries, fnd_responsibility_vl, fnd_form_functions_vl

Report Categories

Enginatics

FND Forms Personalizations, FND Responsibility Access, FND Responsibility Access 11i, FND Menu Entry Upload, FND Menu Entries, Blitz Report Assignments and Responsibilities, FND Responsibility Menu Exclusions

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 User Login Page Favorites 20-Jan-2019 123147.xlsx
Blitz Report™ XML Import FND_User_Login_Page_Favorites.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-user-login-page-favorites/

Executive Summary

The FND User Login Page Favorites report lists the “Favorites” (or “Top Ten”) links that users have configured on their Oracle EBS home page. This provides insight into which functions are most frequently used or deemed most important by the user base.

Business Challenge

During system upgrades, UI redesigns, or role changes, it is helpful to know what shortcuts users rely on. Losing these personalizations can cause user frustration. Additionally, administrators may want to analyze usage patterns to see which functions are actually being prioritized by users.

The Solution

This report extracts the user-defined favorites from the icx_custom_menu_entries table. It allows administrators to:

Technical Architecture

The report queries icx_custom_menu_entries and joins to fnd_form_functions_vl and fnd_responsibility_vl to provide the human-readable names of the functions and responsibilities associated with the favorites.

Parameters & Filtering

Performance & Optimization

This report is lightweight and runs quickly.

FAQ

Q: Can I use this to copy favorites from one user to another? A: This report reads the data. To copy favorites, you would need a separate script or API to insert records into the icx_custom_menu_entries table based on this output.

Q: Does this include the “Navigator” menu? A: No, this is specifically for the “Favorites” list usually displayed on the right side or center of the EBS Home Page.

© 2026 Enginatics