Search Results csi_systems_b

Overview

The CSI_SYSTEMS_B table is the core base table for storing system definitions within Oracle E-Business Suite's Install Base (CSI) module. It represents a logical grouping or configuration of individual item instances (physical assets) that function together as a single, manageable unit. A system provides a higher-level abstraction for service, maintenance, and configuration management, enabling organizations to track relationships and dependencies between components. Its primary role is to serve as the master record for all system entities, supporting critical business processes such as service contracts, field service, depot repair, and asset lifecycle tracking across both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is the SYSTEM_ID, a unique identifier for each system record. As indicated by the foreign key relationships, the table stores essential contextual and hierarchical data. Key columns include CUSTOMER_ID, linking the system to a customer account in HZ_CUST_ACCOUNTS, and various contact IDs (BILL_TO_CONTACT_ID, SHIP_TO_CONTACT_ID, TECHNICAL_CONTACT_ID, SERVICE_ADMIN_CONTACT_ID) referencing HZ_PARTIES. It also holds site information via SHIP_TO_SITE_USE_ID, BILL_TO_SITE_USE_ID, and INSTALL_SITE_USE_ID. Crucially, the table manages system hierarchy and derivation through the PARENT_SYSTEM_ID and AUTOCREATED_FROM_SYSTEM_ID columns, which are self-referencing foreign keys to the same table, allowing for the modeling of parent-child system relationships and automated system creation processes.

Common Use Cases and Queries

A primary use case is generating a report of all systems for a specific customer, including their installation site details. A typical query would join CSI_SYSTEMS_B to HZ_CUST_ACCOUNTS and HZ_CUST_SITE_USES_ALL. Another common scenario involves analyzing system hierarchy to understand configuration relationships, requiring a recursive query or CONNECT BY clause using the PARENT_SYSTEM_ID. Support teams frequently query this table to identify the system context for a service request (CS_INCIDENTS_ALL_B) or to list all item instances (CSI_ITEM_INSTANCES) belonging to a particular system for maintenance planning. For data integrity checks, queries often validate that all SYSTEM_ID values referenced in child transactional tables like CSI_T_TXN_LINE_DETAILS exist in CSI_SYSTEMS_B.

Related Objects

CSI_SYSTEMS_B is central to the Install Base data model. Its most direct relationship is with the CSI_SYSTEMS_H table, which stores the version history for each system. The CSI_ITEM_INSTANCES table, which holds physical asset records, is a critical child table, as instances are grouped into systems. Key transactional interfaces include CSI_T_TXN_LINE_DETAILS. For service management, the CS_INCIDENTS_ALL_B table links service requests to a system. Externally, it integrates heavily with the Trading Community Architecture (TCA) schema for party and site information (HZ_CUST_ACCOUNTS, HZ_PARTIES, HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES). The self-referencing foreign keys for PARENT_SYSTEM_ID and AUTOCREATED_FROM_SYSTEM_ID establish essential relationships within the table itself to manage system structures.