| layout | default |
|---|---|
| title | CSI Installed Base Extended Attributes Summary | Oracle EBS SQL Report |
| description | Master data report of extended Installed Base attribute levels and names – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, CSI, Installed, Base, Extended, csi_iea_values, csi_i_extended_attribs |
| permalink | /CSI%20Installed%20Base%20Extended%20Attributes%20Summary/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Master data report of extended Installed Base attribute levels and names
csi_iea_values, csi_i_extended_attribs
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.
| Resource | Link |
|---|---|
| Excel Example Output | CSI Installed Base Extended Attributes Summary 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | CSI_Installed_Base_Extended_Attributes_Summary.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/csi-installed-base-extended-attributes-summary/ |
The CSI Installed Base Extended Attributes Summary report is a master data management tool for the Oracle Installed Base. It lists the "Extended Attributes" (user-defined fields) that have been configured to track additional technical or business data for item instances. This report helps administrators understand the data model extensions that have been applied to the standard Installed Base functionality.
Standard fields (Item, Serial Number, Owner) are often insufficient for complex products. Companies use Extended Attributes to track specific data like "Software Version," "Calibration Date," or "IP Address."
- Configuration Visibility: As these attributes are custom-defined, it can be hard to get a clear list of what attributes exist and where they are used.
- Data Governance: Ensuring that attributes are named consistently and applied to the correct item categories.
- Reporting: Knowing the attribute names is a prerequisite for building custom reports that query this data.
This report provides a dictionary of the defined Extended Attributes.
Key Features:
- Attribute Definition: Lists the Attribute Name, Level, and other definition details.
- Value Analysis: Can potentially show the distribution of values (depending on the specific query implementation) or just the structure.
The report queries CSI_I_EXTENDED_ATTRIBS and CSI_IEA_VALUES.
Key Tables:
CSI_I_EXTENDED_ATTRIBS: Defines the attribute structure (metadata).CSI_IEA_VALUES: Stores the actual values assigned to specific instances.
- System Documentation: Acts as a data dictionary for the custom attributes in the Installed Base.
- Report Development: Assists developers in finding the correct column/attribute names when building custom queries.
- Standardization: Helps enforce naming conventions for new attributes.
- 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