FND User Login Summary

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Active application user count per month
Run FND User Login Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select distinct
trunc(fl.start_time,'month') month,
count(distinct fl.user_id) over (partition by trunc(fl.start_time,'month')) user_count
from
fnd_logins fl
where
1=1
order by
month desc
Parameter Name SQL text Validation
Logged in within Days 
fl.start_time>=sysdate-:days
 Number
Date From 
fl.start_time>=:date_from
 DateTime
Date To 
fl.start_time<=:date_to
 DateTime
Exclude User Name 
fl.user_id<>xxen_util.user_id(:exclude_user_name)
 LOV
Download
Related Blitz Reports
FND User Login History XXEN: FND User Login History with Geolocation AR Profile Option Migration CST All Inventories Value Report - by Cost Group FND W3H_User_Functions FND W3H_Role_Functions FND W3H_Object_Users FND W3H_Function_Users CST All Inventories Value Report - by Cost Group (1)
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™