ECC Admin - Metadata Attributes – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Enterprise Command Centers metadata attributes
Report Parameters
Application, Data Set, Attribute Key
Oracle EBS Tables Used
ecc_app_ds_relationships, ecc_application_tl, ecc_dataset_b, ecc_dataset_tl, ecc_dataset_attrs_b, ecc_dataset_attrs_tl
Report Categories
Related Reports
ECC Admin - Data Sets, ECC Admin - Data Load Tracking
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 - Metadata Attributes 15-Jun-2020 193045.xlsx |
| Blitz Report™ XML Import | ECC_Admin_Metadata_Attributes.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/ecc-admin-metadata-attributes/ |
ECC Admin - Metadata Attributes
Description
This report provides a detailed view of the metadata attributes defined for Enterprise Command Center (ECC) datasets. It maps the attributes to their respective applications and datasets, offering insight into the data model exposed to the ECC dashboards.
This information is valuable for:
- Customization: Understanding available attributes for dashboard customization.
- Troubleshooting: Verifying that the correct attributes are being loaded and exposed.
- Documentation: Documenting the data elements available in the command center.
Parameters
- Application: Filter by ECC application.
- Data Set: Filter by dataset.
- Attribute Key: Filter by specific attribute key.
Used Tables
ecc_app_ds_relationships: Application-dataset links.ecc_application_tl: Application names.ecc_dataset_b: Dataset definitions.ecc_dataset_tl: Dataset names.ecc_dataset_attrs_b: Attribute base definitions.ecc_dataset_attrs_tl: Attribute translations.
Categories
- Enginatics: ECC metadata analysis.
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
© 2026 Enginatics