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.
Run Blitz Report SQL Validation and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select
xrv.report_name,
xxen_report.validate_sql(xrv.sql_text_full,'parse') error_message,
regexp_substr(xrv.description,'Report ID: (\d+)',1,1,null,1) rwb_report_id,
xrv.category,
xrv.sql_text
from
xxen_reports_v xrv
where
1=1
) x
where
x.error_message is not null
order by
x.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
)
LOV