DIS Users

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Discoverer end user layer users of different types (application user, responsibility, database user)

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
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: