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™.
Overview
Creates a string for the record history columns, based on a table alias.
Report Parameters
Table Alias, Prefix
Oracle EBS Tables Used
Report Categories
Related Reports
CAC Inventory Accounts Setup, INV Item Attribute Master/Child Conflicts, DBA ORDS Configuration Validation, DBA Blitz Report ORDS Configuration, ECC Admin - Concurrent Programs, CAC Cost Group Accounts Setup, OPM Reconcilation, CAC Manufacturing Variance
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 Record History SQL Text Creation 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | Blitz_Report_Record_History_SQL_Text_Creation.xml |
| Full SQL 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
- Generates SQL for standard record history columns:
creation_date,created_by,last_update_date,last_updated_by,last_update_login. - Accepts a user-defined table alias to prefix the columns.
- Allows for an optional prefix to be added to the column aliases, useful when joining multiple tables with history columns.
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.
Useful Links
- 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