Blitz Report Record History SQL Text Creation – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Blitz Report · all Blitz Report reports

Overview

Creates a string for the record history columns, based on a table alias.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Table Alias, Prefix

Oracle EBS Tables Used

dual

Report Categories

Enginatics

DBA Database Parameter Validation, INV Item Attribute Master/Child Conflicts, DBA ORDS Configuration Validation, ECC Admin - Concurrent Programs, CAC Interface Error Summary, OPM Reconcilation, AP Invoices and Lines

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Blitz Report Record History SQL Text Creation 04-Apr-2026 123137.xlsx
Blitz Report™ XML Import Blitz_Report_Record_History_SQL_Text_Creation.xml
SQL Source Blitz Report Record History SQL Text Creation.sql
Full Report on Enginatics www.enginatics.com/reports/blitz-report-record-history-sql-text-creation/

Executive Summary

This utility report generates the SQL syntax required to include standard Oracle EBS record history columns (Who columns) in a query, based on a provided table alias.

Business Challenge

When developing custom SQL reports in Oracle EBS, developers frequently need to include the standard “Who” columns (Created By, Creation Date, Last Updated By, Last Update Date, Last Update Login) to track record history. Manually typing these columns for every table alias is repetitive and prone to typos.

Solution

The Blitz Report Record History SQL Text Creation tool automates this process. By simply inputting the table alias and an optional prefix, it generates the exact SQL code snippet needed to select these columns, formatted correctly with the specified alias.

Key Features

Technical Details

The report uses a simple query against the dual table to concatenate the input parameters into the required SQL string format. It outputs a text string that can be directly copied and pasted into a SQL editor or report definition.

© Enginatics GmbH