FND User Login Summary

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
Blitz Report™