CSI Installed Base Summary by Organization – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Count of installed base products by hierarchy type (parent / child), instance usage and related organizations, such as sold from and owner operating unit, last validation and master inventory organization
Report Parameters
Show Status
Oracle EBS Tables Used
hz_cust_accounts, hz_cust_acct_sites_all, hz_cust_site_uses_all, hr_all_organization_units_vl, csi_item_instances, csi_ii_relationships, hz_parties, csi_i_org_assignments, fnd_user, csi_instance_statuses
Report Categories
Related Reports
OKL Termination Quotes, AR Transactions and Lines 11i, CSI Customer Products Summary
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 Summary by Organization 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | CSI_Installed_Base_Summary_by_Organization.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/csi-installed-base-summary-by-organization/ |
Executive Summary
The CSI Installed Base Summary by Organization report provides a statistical overview of the Installed Base, aggregated by organization and hierarchy. It counts the number of item instances based on their usage (e.g., “Sold To,” “Ship To”) and their relationship within the system (Parent/Child). This high-level view is useful for operational reporting and validating data migration or synchronization processes.
Business Challenge
Managing millions of installed base records requires high-level metrics to ensure data health.
- Volume Analysis: “How many active instances do we have in the US vs. Europe?”
- Data Integrity: “Do we have instances that are owned by an inactive organization?”
- Hierarchy Validation: Ensuring that the parent-child relationships (e.g., System -> Component) are being maintained.
Solution
This report aggregates instance counts by various organizational dimensions.
Key Features:
- Hierarchy Analysis: Counts instances by their parent/child relationship type.
- Usage Breakdown: Segments the base by “Instance Usage” (e.g., External, Internal, In-Transit).
- Organizational Context: Shows the “Sold From” and “Owner” operating units.
Architecture
The report aggregates data from CSI_ITEM_INSTANCES and CSI_II_RELATIONSHIPS.
Key Tables:
CSI_ITEM_INSTANCES: The core instance data.CSI_II_RELATIONSHIPS: Defines the structure (parent/child) between instances.CSI_I_ORG_ASSIGNMENTS: Links instances to specific organizations.HR_ALL_ORGANIZATION_UNITS: Organization details.
Impact
- Operational Monitoring: Tracks the growth of the installed base over time.
- Data Quality: Helps identify “orphan” records or instances with invalid organizational assignments.
- Strategic Planning: Provides the volume data needed to plan for storage or service capacity.
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