| layout | default |
|---|---|
| title | Blitz Report Text Search | Oracle EBS SQL Report |
| description | This report can be used to understand which reports, parameters or LOVs contain a certain SQL Text string, or which reports currently use a specific LOV… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Blitz, Report, Text, Search, xxen_reports_v, xxen_report_parameters_v, xxen_report_parameter_lovs |
| permalink | /Blitz%20Report%20Text%20Search/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
This report can be used to understand which reports, parameters or LOVs contain a certain SQL Text string, or which reports currently use a specific LOV.
It is used to preview all records that would be changed through the Blitz Report mass change functionality in Setup Window>Tools>Mass Change
SQL Text contains, Category, Record Type, Match case, Regex mode, SQL Text does not contain, Report Name
xxen_reports_v, xxen_report_parameters_v, xxen_report_parameter_lovs, xxen_upload_columns_v, xxen_upload_sqls_v
Blitz Report LOV Comparison between environments, DIS End User Layers, Blitz Report LOV SQL Validation, Blitz Report LOVs, Blitz Report History, Blitz Report Comparison between environments, Blitz Reports, Blitz Upload Dependencies, Blitz Report Security
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.
| Resource | Link |
|---|---|
| Excel Example Output | None |
| Blitz Report™ XML Import | Blitz_Report_Text_Search.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/blitz-report-text-search/ |
The Blitz Report Text Search tool is a powerful utility designed to search for specific SQL text strings across reports, parameters, and Lists of Values (LOVs) within the Oracle E-Business Suite environment. It is particularly useful for identifying dependencies and usage of specific code snippets or LOVs, and for previewing records that would be affected by mass change operations.
Managing a large repository of reports and their associated components in Oracle EBS can be challenging. Developers and administrators often need to find where specific SQL logic or LOVs are used to assess the impact of changes, debug issues, or ensure consistency. Manually searching through each report definition is time-consuming and prone to error. Additionally, performing mass updates requires a safe way to preview affected records before committing changes.
The Blitz Report Text Search provides a centralized search mechanism that scans the definitions of reports, parameters, and LOVs for a specified text string. It allows users to filter by category, record type, and report name, and supports case-sensitive and regex-based searches. This tool streamlines impact analysis and facilitates safe mass updates by offering a preview capability.
- Comprehensive Search: Searches across reports, parameters, and LOVs for a given SQL text string.
- Impact Analysis: Identifies which reports use a specific LOV or contain specific SQL logic.
- Mass Change Preview: Used to preview records that would be modified by the Blitz Report mass change functionality.
- Advanced Filtering: Supports filtering by category, record type, and report name.
- Flexible Search Options: Includes options for case matching and regular expression (regex) mode.
- Exclusion Criteria: Allows specifying text strings to exclude from the search results.
The report queries several internal Blitz Report views and tables, including xxen_reports_v, xxen_report_parameters_v, xxen_report_parameter_lovs, xxen_upload_columns_v, and xxen_upload_sqls_v. It leverages these views to inspect the underlying SQL definitions and configuration details of the reporting environment.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics