Blitz Report User History

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
Lists all active EBS users with their active responsibilities and blitz report execution counts.
The report can be used to analyze blitz report usage within the EBS user community e.g. to find the most active users or to spot the ones not using blitz report to it's full potential yet.
Run Blitz Report User History and other Oracle EBS reports with Blitz Report™ on our demo environment
select
xxen_util.user_name(fu.user_id) user_name,
fu.last_logon_date,
xrr.execution_count,
xrr.report_count,
frv.responsibility_name,
fav.application_name,
frg.request_group_name,
fav2.application_name group_application_name
from
fnd_user fu,
fnd_user_resp_groups furg,
fnd_responsibility_vl frv,
fnd_application_vl fav,
fnd_request_groups frg,
fnd_application_vl fav2,
(
select distinct
xrr.created_by,
count(*) over (partition by xrr.created_by) execution_count,
count(distinct xrr.report_id) over (partition by xrr.created_by) report_count
from
xxen_report_runs xrr
where
1=1
) xrr
where
2=2 and
trunc(sysdate) between fu.start_date and nvl(fu.end_date,sysdate) and
fu.user_id=furg.user_id and
furg.responsibility_application_id=frv.application_id and
furg.responsibility_id=frv.responsibility_id and
trunc(sysdate) between frv.start_date and nvl(frv.end_date,sysdate) and
furg.responsibility_application_id=fav.application_id and
frv.group_application_id=frg.application_id(+) and
frv.request_group_id=frg.request_group_id(+) and
frv.group_application_id=fav2.application_id(+) and
fu.user_id=xrr.created_by(+)
order by
xrr.execution_count desc nulls last,
user_name,
frv.responsibility_name
Parameter Name SQL text Validation
Last Logon Date within x days 
fu.last_logon_date>=sysdate-:logon_days
 Number
Executions within x days 
xrr.creation_date>sysdate-:days
 Number
Download
 
Related Blitz Reports
FND Access Control 11i FND Responsibility Access 11i FND Responsibility Access CAC Inventory Pending Cost Adjustment CAC ICP PII Inventory Pending Cost Adjustment FND User Responsibilities CAC ICP PII Material Account Detail CAC Material Account Detail INV Inventory Item Upload
Blitz Report™

Blitz Report™ provides multiple benefits: