| layout | default |
|---|---|
| title | FND User Login Summary | Oracle EBS SQL Report |
| description | Active application user count per month – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, User, Login, Summary, fnd_logins |
| permalink | /FND%20User%20Login%20Summary/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Active application user count per month
Logged in within Days, Date From, Date To, Exclude User Name
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
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.
| 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/ |
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.
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.
This report aggregates login data to produce a monthly count of unique users. It helps management:
- Monitor system adoption rates.
- Validate licensing compliance (active user counts).
- Identify seasonal trends in system usage.
The report performs a count distinct operation on the fnd_logins table, grouped by month.
- Date Range: Define the period for the summary (e.g., last 12 months).
- Exclude User Name: Option to exclude system accounts (like GUEST or SYSADMIN) to get a more accurate count of real human users.
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.
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.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics