DIS Users

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
Discoverer end user layer users of different types (application user, responsibility, database user)
Run DIS Users and other Oracle EBS reports with Blitz Report™ on our demo environment
select
eeu.eu_id,
xxen_util.dis_user_type(eeu.eu_username) type,
xxen_util.dis_user_name(eeu.eu_username) name,
eqs.access_count,
eqs.last_accessed,
xxen_util.dis_user_name(eeu.eu_created_by) created_by,
eeu.eu_created_date creation_date,
xxen_util.dis_user_name(eeu.eu_updated_by) last_updated_by,
eeu.eu_updated_date last_update_date
from
&eul.eul5_eul_users eeu,
(
select
eqs.qs_created_by,
count(*) access_count,
max(eqs.qs_created_date) last_accessed
from
&eul.eul5_qpp_stats eqs
where
2=2
group by
eqs.qs_created_by
) eqs
where
1=1 and
eeu.eu_username=eqs.qs_created_by(+)
order by
eeu.eu_updated_date desc
Parameter Name SQL text Validation
Access Count within x Days 
eqs.qs_created_date>sysdate-:days
 Number
Show Active only 
eqs.qs_created_by is not null
 LOV
End User Layer 
<parameter_value>
 LOV
Download
 
Related Blitz Reports
DIS Access Privileges DIS Workbooks, Folders, Items and LOVs DIS Folders, Business Areas, Items and LOVs DIS Workbook Import Validation DIS Workbook Export Script DIS Business Areas DIS Worksheet Execution History DIS Worksheet Execution Summary DIS Worksheet SQLs
Blitz Report™

Blitz Report™ provides multiple benefits: