Blitz Report LOV SQL Validation

Description
Categories: Enginatics
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 LOV SQL Validation and other Oracle EBS reports with Blitz Report™ on our demo environment
select
y.*
from
(
select
x.*,
nvl2(x.error_message,'Error','Valid') validation_result
from
(
select
xrpl.lov_name,
xxen_report.validate_sql(replace(xrpl.lov_query,':$flex$.',':'),'parse') error_message,
xrpl.lov_query
from
xxen_report_parameter_lovs xrpl
where
1=1
) x
) y
where
2=2
order by
y.lov_name
Parameter Name SQL text Validation
LOV Name like
lower(xrl.lov_name) like lower(:lov_name_like)
LOV
Category
xrpl.lov_id in (
select
xrp.lov_id
from
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca,
xxen_report_parameters xrp
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id and
xrca.report_id=xrp.report_id and
xrp.parameter_type='LOV'
)
LOV
Validation Result
y.validation_result=:validation_result
LOV
Blitz Report™