FND User Login Page Favorites – 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

User’s HTML favourites from table icx_custom_menu_entries

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 Name

Oracle EBS Tables Used

icx_custom_menu_entries, fnd_responsibility_vl, fnd_form_functions_vl

Report Categories

Enginatics

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

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 FND User Login Page Favorites 20-Jan-2019 123147.xlsx
Blitz Report™ XML Import FND_User_Login_Page_Favorites.xml
SQL Source FND User Login Page Favorites.sql
Full Report 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.

© Enginatics GmbH