CSI Installed Base Summary by Organization – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Installed Base · all Installed Base reports
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
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
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
CSI Customer Products Summary, OKL Termination Quotes, OKS Service Contract Line Upload, AR Transactions and Lines 11i, CS Service Requests, INV Items
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 | CSI Installed Base Summary by Organization 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | CSI_Installed_Base_Summary_by_Organization.xml |
| SQL Source | CSI Installed Base Summary by Organization.sql |
| Full Report 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
© Enginatics GmbH