DIS Import Performance

Description

Categories: Enginatics, Kcapps, Toolkit - Setup & Support
Repository: Github

Simple query to review Discoverer worksheet to Blitz Report import performance, when running the mass migration script.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet

DIS Import Performance and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

select
xrv.report_name,
xrv.category,
xxen_util.user_name(xrv.created_by) created_by,
xrv.creation_date,
xxen_util.time((xrv.creation_date-lag(xrv.creation_date) over (order by xrv.report_id))*86400) time
from
xxen_reports_v xrv
where
1=1
order by
xrv.report_id desc

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
)