ECC Admin - Data Load Tracking – Oracle EBS SQL Report

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

Overview

Enterprise Command Center data load run history, including status, the load SQL and possible error messages in case of failures. For description of the load process, see ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/

Report Parameters

Run Id, Application, Data Set, Load Type, Status, Running within past x Days, Start Date From, Start Date To, Show Load Rules, Show SQLs

Oracle EBS Tables Used

ecc_application_tl, ecc_dataset_b, ecc_audit_request, ecc_audit_dataset, ecc_dataset_tl, ecc_audit_load_rule, ecc_audit_load_details

Report Categories

Enginatics, R12 only

ECC Admin - Data Sets, ECC Admin - Metadata Attributes

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	ECC Admin - Data Load Tracking 15-Jun-2020 193916.xlsx
Blitz Report™ XML Import	ECC_Admin_Data_Load_Tracking.xml
Full SQL on Enginatics	www.enginatics.com/reports/ecc-admin-data-load-tracking/

ECC Admin - Data Load Tracking

Description

This report provides a detailed history of Enterprise Command Center (ECC) data load runs. It is a crucial tool for administrators to monitor the health and status of data synchronization processes.

Key features include:

Execution Status: Tracks the success, failure, or progress of data loads.
Error Analysis: Captures error messages and SQL queries associated with failed loads, facilitating rapid troubleshooting.
Load Details: Displays the specific dataset, application, and load type (Full vs. Incremental).

By using this report, administrators can ensure that the ECC dashboards are displaying the most current and accurate data.

Parameters

Run Id: Filter by specific load run ID.
Application: Filter by ECC application.
Data Set: Filter by specific dataset.
Load Type: Filter by load type (e.g., FULL_LOAD, INCREMENTAL_LOAD).
Status: Filter by execution status (e.g., SUCCESS, ERROR).
Running within past x Days: Filter for recent activity.
Start Date From/To: Define a custom date range.
Show Load Rules: Toggle display of load rules.
Show SQLs: Toggle display of the underlying SQL executed during the load.

Used Tables

ecc_application_tl: ECC application translations.
ecc_dataset_b: ECC dataset base definitions.
ecc_audit_request: Audit log for load requests.
ecc_audit_dataset: Audit log for dataset loads.
ecc_dataset_tl: ECC dataset translations.
ecc_audit_load_rule: Audit log for load rules.
ecc_audit_load_details: Detailed audit logs.

Categories

Enginatics: ECC administration and monitoring.

Useful Links

© 2026 Enginatics