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

Active application user count per month

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

Logged in within Days, Date From, Date To, Exclude User Name

Oracle EBS Tables Used

fnd_logins

Report Categories

Enginatics

FND User Login History, FND Concurrent Requests, FND Responsibility Access

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_User_Login_Summary.xml
SQL Source FND User Login Summary.sql
Full Report on Enginatics www.enginatics.com/reports/fnd-user-login-summary/

Executive Summary

The FND User Login Summary report provides a high-level statistical view of system usage, specifically showing the count of active user logins per month. It is designed for trend analysis and license management.

Business Challenge

Organizations need to track adoption and usage trends over time. Are more users logging in this year compared to last year? Is usage declining in certain months? Additionally, some software licensing models are based on “Active Users” per month.

The Solution

This report aggregates login data to produce a monthly count of unique users. It helps management:

Technical Architecture

The report performs a count distinct operation on the fnd_logins table, grouped by month.

Parameters & Filtering

Performance & Optimization

Aggregating the fnd_logins table can be resource-intensive if the table is very large and never purged. Using the Date parameters is recommended to limit the scan range.

FAQ

Q: Does this count concurrent users? A: No, this counts the total number of unique users who logged in at least once during the month. It does not show peak concurrent usage (users logged in at the exact same second).

Q: If a user logs in 100 times, are they counted 100 times? A: No, the report counts unique users per month. One user logging in 100 times counts as 1 active user for that month.

© Enginatics GmbH