DIS Import Performance

Description
Categories: Enginatics, Kcapps, Toolkit - Setup & Support
Repository: Github
Query to review Discoverer to Blitz Report import performance, after running the 'Blitz Report Discoverer Import' concurrent program or mass migration script.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet
Run DIS Import Performance and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*,
xxen_util.time(x.seconds) time
from
(
select
xrv.report_name,
regexp_substr(xrv.description,'Object IDs: (.+)',1,1,null,1) object_use_key,
xrv.category,
xxen_util.user_name(xrv.created_by) created_by,
xxen_util.client_time(xrv.creation_date) creation_date,
(xrv.creation_date-lag(xrv.creation_date) over (order by xrv.report_id))*86400 seconds
from
xxen_reports_v xrv
where
1=1
order by
xrv.report_id desc
) x
Parameter Name SQL text Validation
Report Creation Time From
xrv.creation_date>=:date_from
DateTime
Report Creation Time To
xrv.creation_date<=:date_to
DateTime
Category
xrv.report_id in (
select
xrca.report_id
from  
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca
where
xrcv.category=:category_name and
xrcv.category_id=xrca.category_id
)
LOV