Blitz Report SQL Validation

Description

Categories: Enginatics, RWB
Repository: Github

Validates Blitz Reports for valid SQL syntax.
This can be useful after mass migrating reports from other tools such as Discoverer, Excl4apps, splashBI or Polaris Reporting Workbench into Blitz Report.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

select
y.*
from
(
select
x.*,
nvl2(x.error_message,'Error','Valid') validation_result
from
(
select
xrv.report_name,
xxen_report.validate_sql(&sql_text_full,'parse') error_message,
xrv.type_dsp type,
xrv.category,
xrv.sql_text,
regexp_substr(xrv.description,'Report ID: (\d+)',1,1,null,1) orig_report_id
from
xxen_reports_v xrv
where
1=1
) x
) y
where
2=2
order by
y.report_name

Parameter Name

SQL text

Validation

Report Name like

lower(xrv.report_name) like lower(:report_name_like)

LOV

Category

xrv.report_id in (
select
xrca.report_id
from
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)