Blitz Report Parameter Anchor Validation

Description

Categories: Enginatics
Repository: Github

Checks if all parameter anchors exist in the xxen_report_parameter_anchors table.

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

Copy

select
xrpv.report_name,
xrpv.category,
xrpv.display_sequence,
xrpv.parameter_name,
xrpv.anchor,
xrpv.sql_text,
(select count(*) from xxen_report_parameter_anchors xrpa where xrpv.report_id=xrpa.report_id) report_anchor_count,
xxen_util.user_name(xrpv.created_by) created_by,
xxen_util.client_time(xrpv.creation_date) creation_date,
xxen_util.user_name(xrpv.last_updated_by) last_updated_by,
xxen_util.client_time(xrpv.last_update_date) last_update_date,
xrpv.report_id,
xrpv.parameter_id
from
xxen_report_parameters_v xrpv
where
1=1 and
(xrpv.report_id,xrpv.anchor) not in (select xrpa.report_id, xrpa.anchor from xxen_report_parameter_anchors xrpa)
order by
xrpv.report_name,
xrpv.sort_order

Parameter Name

SQL text

Validation

Category

xrpv.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
)