ECC Admin - Metadata Attributes – 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 Centers metadata attributes
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
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
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 - Metadata Attributes 15-Jun-2020 193045.xlsx |
| Blitz Report™ XML Import | ECC_Admin_Metadata_Attributes.xml |
| SQL Source | ECC Admin - Metadata Attributes.sql |
| Full Report 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
© Enginatics GmbH