ECC Admin - Data Load Tracking – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Enterprise Command Center · all Enterprise Command Center reports
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/?utm_source=oraclereporting.com&utm_medium=referral&utm_campaign=oracle-ebs-sql&utm_content=ecc-admin-data-load-tracking
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
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
Related Reports
ECC Admin - Data Sets, ECC Admin - Metadata Attributes
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 | ECC Admin - Data Load Tracking 15-Jun-2020 193916.xlsx |
| Blitz Report™ XML Import | ECC_Admin_Data_Load_Tracking.xml |
| SQL Source | ECC Admin - Data Load Tracking.sql |
| Full Report 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.
Related Reports
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
© Enginatics GmbH