Skip to the content.

Blitz Upload Data – 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

History of uploaded data, which is kept for profile option Blitz Upload Data Retention Days number of days.

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

Upload Name, User Name, Started within Days, Upload Request Id, Report Request Id, Run Id, Maximum rows per upload

Oracle EBS Tables Used

xxen_upload_data, xxen_report_runs, xxen_reports_v, fnd_responsibility_tl

Report Categories

Enginatics

Blitz Upload History, Blitz Report History, Blitz Reports, Blitz Report Web Service Sessions, DBA Sessions

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 Upload Data 19-Jun-2025 063352.xlsx
Blitz Report™ XML Import Blitz_Upload_Data.xml
SQL Source Blitz Upload Data.sql
Full Report on Enginatics www.enginatics.com/reports/blitz-upload-data/

Executive Summary

The Blitz Upload Data report provides a historical record of data uploaded via Blitz Report. It tracks upload events, including user details, request IDs, and the volume of data processed, serving as an audit trail for data import activities.

Business Challenge

Organizations using Blitz Report for data uploads need visibility into what data is being imported, by whom, and when. Without a log of upload activities, it is difficult to troubleshoot issues, audit changes, or monitor system usage related to data imports.

Solution

This report offers a detailed history of data uploads, retained for a configurable period (defined by the “Blitz Upload Data Retention Days” profile option). It allows administrators to review past uploads, verify successful processing, and analyze usage patterns.

Key Features

Technical Details

The report queries the xxen_upload_data table, which stores the actual uploaded data, and joins it with xxen_report_runs and xxen_reports_v to provide context about the report execution. It also references fnd_responsibility_tl for responsibility information.


© Enginatics GmbH