FND User Login Summary

Description
Categories: Enginatics
Repository: Github
Active application user count per month

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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