Blitz Report Parameter Link Validation – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Lists orphaned parameter rows: additional-anchor (sub) parameter rows - those without a display sequence - that do not link to a visible parameter of the same name in the same report (parameter_id not in xxen_report_parameters_link_v).

These are typically left behind by an incomplete parameter rename (e.g. ‘Show DFF Attributes’ to ‘DFF Display’), leaving the old-named multi-anchor sub-rows dangling.

The run-time SQL is assembled solely from xxen_report_parameters_link_v, so an unlinked sub-row is never injected and is harmless at run time, but it clutters the parameter setup and would re-activate unexpectedly if a visible parameter with the old name were re-created.

Use the Category parameter to limit the scope.

Report Parameters

Category

Oracle EBS Tables Used

xxen_report_parameters_v, xxen_report_parameters_link_v

Report Categories

Enginatics

Blitz Report LOV Comparison between environments, Blitz Report Parameter Table Alias Validation, Blitz Report Parameter Bind Variable Validation, Blitz Report Parameter Comparison between environments, GL Account Distribution Analysis, Blitz Report Comparison between environments, Blitz Report Parameter Comparison between reports, CAC AP Accrual IR ISO Match Analysis

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output
Blitz Report™ XML Import Blitz_Report_Parameter_Link_Validation.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-parameter-link-validation/

© 2026 Enginatics