Blitz Report Parameter Anchor Validation

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Checks if all parameter anchors exist in the xxen_report_parameter_anchors table.
Run Blitz Report Parameter Anchor Validation and other Oracle EBS reports with Blitz Report™ on our demo environment
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
)
 LOV
Download
Related Blitz Reports
Blitz Reports Blitz Report Text Search DIS End User Layers Blitz Report Parameters with more than one :bind variable Blitz Report LOVs Blitz Report Parameter Default Values Blitz Report Parameter Dependencies Blitz Report Execution History Blitz Report Parameter Comparison between reports
Blitz Report™

Blitz Report™ provides multiple benefits: