FND User Login Summary – Oracle EBS SQL Report

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

Overview

Active application user count per month

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, AR Unaccounted Transaction Sweep, CAC Subinventory Accounts Setup, FA Additions By Source, CAC Cost Group Accounts Setup, CAC Shipping Network (Inter-Org) Accounts Setup, FND Concurrent Requests 11i

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 None
Blitz Report™ XML Import FND_User_Login_Summary.xml
Full SQL 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.

© 2026 Enginatics