Skip to content

README.md

Latest commit

 

History

History
71 lines (51 loc) · 4.86 KB

README.md

File metadata and controls

71 lines (51 loc) · 4.86 KB
layout default
title Blitz Upload Data | Oracle EBS SQL Report
description History of uploaded data, which is kept for profile option Blitz Upload Data Retention Days number of days.
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Blitz, Upload, Data, xxen_upload_data, xxen_report_runs, xxen_reports_v
permalink /Blitz%20Upload%20Data/

Blitz Upload Data – Oracle EBS SQL Report

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

Overview

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

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

Related Reports

Blitz Upload History, Blitz Report History, Blitz Reports, Blitz Report License Users, Blitz Report License User History, CST Item Standard Cost Upload

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 Upload Data 19-Jun-2025 063352.xlsx
Blitz Report™ XML Import Blitz_Upload_Data.xml
Full SQL 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

  • Upload History: Lists historical data uploads with timestamps and user information.
  • Detailed Tracking: Captures Upload Name, User Name, Request IDs, and Run IDs.
  • Volume Monitoring: Shows the number of rows processed per upload.
  • Retention Management: Respects the configured data retention policy.

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.

Useful Links

© 2026 Enginatics