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.

Blitz Report SQL Validation and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

select
y.*
from
(
select
x.*,
nvl2(x.error_message,'Error','Valid') validation_result
from
(
select
xrv.report_name,
xxen_report.validate_sql(xrv.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
)