Blitz Report Parameter Default Value Validation – Oracle EBS SQL Report

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

Overview

Lists report parameters whose LOV returns an id that differs from the displayed value, and shows whether the parameter’s default value is stored as that id or as the display text.

Default Value Correct is the id the LOV resolves the stored default to. Where it differs from Default Value, the default was entered as the display value instead of the id. Use the ‘Show non matching defaults only’ parameter to list those cases.

The framework binds the id for such LOVs, so a report level default given as display text only works through a fallback validation, which costs an additional LOV execution every time the run screen opens and is ambiguous if the same text also exists as an id. Template and user level defaults are matched against the id only, so there the display text does not resolve at all.

Is Function and Is Select show whether the default is expressed as a function, e.g. fnd_profile.value, or as a select statement, and Dupl Count how many of the listed parameters share the identical default expression.

Use the Category and Report Name parameters to limit the scope.

Report Parameters

Category, Report Name, Show non matching defaults only, Show functions ony, Show selects only

Oracle EBS Tables Used

xxen_report_parameters_v

Report Categories

Enginatics

INV Transaction Historical Summary, Blitz Report Parameter Comparison between reports, CAC WIP Resource Efficiency, Blitz Report Parameter Link Validation, CAC Inventory Organization Summary, INV Physical Inventory Purge Upload, Blitz Report LOV SQL Validation, Blitz Report Text Search, CAC WIP Account Value, 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_Default_Value_Validation.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-parameter-default-value-validation/

© 2026 Enginatics