Skip to content

Blitz Report Comparison between environments

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

Blitz Report Comparison between environments

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Blitz Report Comparison between environments.sql
Blitz Report Comparison between environments.sql
 
 
DESCRIPTION.md
DESCRIPTION.md
 
 
README.md
README.md
 
 

README.md

layout default
title Blitz Report Comparison between environments | Oracle EBS SQL Report
description Shows Blitz Report differences between the local and a remote database server. Requires following view to be created on the remote environment to avoid…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Blitz, Report, Comparison, between, fnd_user, xxen_report_parameters, xxen_reports_v
permalink /Blitz%20Report%20Comparison%20between%20environments/

Blitz Report Comparison between environments – Oracle EBS SQL Report

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

Overview

Shows Blitz Report differences between the local and a remote database server.

Requires following view to be created on the remote environment to avoid ORA-64202: remote temporary or abstract LOB locator is encountered

create or replace view xxen_reports_v_ as select xrv.*, dbms_lob.substr(xxen_util.clob_substrb(xrv.sql_text_full,4000,1)) sql_text_short from xxen_reports_v xrv;

Report Parameters

Remote Database, Category, Report Name like, Show Differences only

Oracle EBS Tables Used

fnd_user, xxen_report_parameters, xxen_reports_v, xxen_reports_v_

Report Categories

Enginatics

Related Reports

Blitz Report LOV Comparison between environments, Blitz Reports, Blitz Report History, CAC Inventory Organization Summary, GL Account Analysis (Distributions), CAC Interface Error Summary, DIS End User Layers, GL Account Distribution Analysis, Blitz Upload Dependencies

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 Comparison between environments 20-Feb-2024 002703.xlsx
Blitz Report™ XML Import Blitz_Report_Comparison_between_environments.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-comparison-between-environments/

Blitz Report Comparison between environments - Case Study & Technical Analysis

Executive Summary

Blitz Report Comparison between environments is the ultimate configuration management tool for Blitz Reports. It compares the full definition of reports—including SQL code, parameters, and assignments—between two environments. This is the primary tool used to validate a release or migration.

Business Challenge

  • Code Drift: A developer makes a "quick fix" in Production but forgets to apply it to Development. Over time, the environments diverge.
  • Release Validation: Confirming that the SQL code in Production exactly matches the approved version in UAT.
  • Parameter Mismatches: Ensuring that default parameter values (e.g., "Period-End") are consistent.

Solution

This report performs a deep comparison of the report definitions.

  • SQL Comparison: It compares the SQL text (often handling CLOBs) to detect changes in the logic.
  • Parameter Check: It verifies that the parameter lists and their attributes (mandatory, default values, LOVs) match.
  • Version Control: It helps maintain a synchronized landscape.

Technical Architecture

Key Tables

  • XXEN_REPORTS_V: The main report definition view.
  • XXEN_REPORT_PARAMETERS: The parameter definitions.
  • Remote View (XXEN_REPORTS_V_): The README notes a requirement to create a specific view on the remote environment to handle CLOBs (Large Objects) over a database link, as standard DB links can struggle with large SQL text fields.

Logic

  1. Remote Access: Connects via DB Link.
  2. SQL Normalization: It often compares a "short" version or a hash of the SQL to detect changes efficiently, or uses the special view to pull the CLOB data.
  3. Diffing: It flags records where the local definition does not match the remote definition.

Parameters

  • Remote Database: The target environment for comparison.
  • Category: Filter comparison by report category.
  • Report Name like: Compare a specific report or set of reports.
  • Show Differences only: The most common mode, hiding all the reports that are in sync.

Useful Links

© 2026 Enginatics