CSI Installed Base Extended Attributes Summary – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Master data report of extended Installed Base attribute levels and names
Report Parameters
Oracle EBS Tables Used
csi_iea_values, csi_i_extended_attribs
Report Categories
Related Reports
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 | 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/ |
Executive 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.
Business Challenge
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.
Solution
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.
Architecture
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.
Impact
- 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.
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