Results for “cs_systems_all_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_SYSTEMS_ALL_B is the base table in the Oracle E-Business Suite Service (CS) module that stores the definition of customer "systems" — the install-base objects that represent a customer's installed equipment configuration. A system is the top-level container to which installed customer products (instance-tracked items) are attached, and it is the entity against which service requests, contracts, and depot repair activities are typically organized. The table is a multi-org (_ALL) table, meaning rows are partitioned by operating unit through the standard ORG_ID mechanism, and it participates in the Service "install base" model alongside customer products, instance details, and service request links.

The ETRM metadata lists Not implemented in this database under Implementation/DBA Data, which indicates the table was not deployed in the reference database instance from which the documentation was mined; the structure and relationships described here therefore reflect the intended Oracle EBS 12.1.1 / 12.2.2 data model. Based on the foreign key topology — heavy outward references to HZ_CUST_ACCOUNTS, HZ_PARTIES, and HZ_PARTY_SITES, plus multiple inbound references from dependent Service tables — the heuristic Data Vault classification is satellite-leaning. In a Data Vault model this would suggest treating SYSTEM_ID as the hub business key and the descriptive and relationship attributes as satellite content, rather than as a pure transactional link.

Key Information Stored

• SYSTEM_ID — surrogate primary key, enforced by CS_SYSTEMS_ALL_B_PK. This is the single-column primary key and the identifier referenced by all dependent tables.
• CUSTOMER_ID — foreign key to HZ_CUST_ACCOUNTS; identifies the customer account that owns the system.
• PARENT_SYSTEM_ID — self-referencing foreign key to CS_SYSTEMS_ALL_B; enables hierarchical system structures (a system may roll up under a parent system).
• AUTOCREATED_FROM_SYSTEM_ID — self-referencing foreign key indicating the system from which this row was automatically generated, supporting configurator or clone-based creation.
• TECHNICAL_CONTACT_ID — foreign key to HZ_PARTIES; the party responsible for technical contact on the system.
• SERVICE_ADMIN_CONTACT_ID — foreign key to HZ_PARTIES; the service administration contact.
• SHIP_TO_CONTACT_ID, BILL_TO_CONTACT_ID — foreign keys to HZ_PARTIES for ship-to and bill-to party contacts.
• SHIP_TO_SITE_USE_ID, INSTALL_SITE_USE_ID — foreign keys to HZ_PARTY_SITES; the ship-to and installation site-use records.
• BILL_TO_SITE_USE_ID — foreign key to HZ_CUST_ACCT_SITES_ALL; the bill-to site-use record for the customer account.

The metadata documents only CS_SYSTEMS_ALL_B_PK as the unique index; no separate business-key unique index is listed, so SYSTEM_ID should be treated as the sole documented unique identifier. All other columns named above are relationship-bearing attributes rather than business keys.

Common Use Cases and Queries

Typical usage centers on install-base reporting and service request resolution. A common pattern joins the system to its owning customer account and its child installed products:

• Locating all systems for a customer: SELECT system_id FROM cs_systems_all_b WHERE customer_id = :cust_id.
• Tracing system hierarchy: self-joins on parent_system_id to reconstruct parent/child rollups across cs_systems_all_b.
• Identifying auto-created systems: querying autocreated_from_system_id to audit systems generated by cloning or propagation.
• Install-base reconciliation: joining CS_CUSTOMER_PRODUCTS_ALL.SYSTEM_ID to CS_SYSTEMS_ALL_B.SYSTEM_ID to enumerate products under each system.
• Service request linkage: joining CS_SYSTEM_SR_LINKS.SYSTEM_ID to associate service requests with the affected system.
• Audit and history analysis: joining CS_SYSTEM_AUDIT on SYSTEM_ID, OLD_PARENT_SYSTEM_ID, or CURR_PARENT_SYSTEM_ID for parentage change tracking.

Related Objects

• HZ_CUST_ACCOUNTS — joined via CS_SYSTEMS_ALL_B.CUSTOMER_ID.
• HZ_PARTIES — joined via TECHNICAL_CONTACT_ID, SERVICE_ADMIN_CONTACT_ID, SHIP_TO_CONTACT_ID, and BILL_TO_CONTACT_ID.
• HZ_PARTY_SITES — joined via SHIP_TO_SITE_USE_ID and INSTALL_SITE_USE_ID.
• HZ_CUST_ACCT_SITES_ALL — joined via BILL_TO_SITE_USE_ID.
• CS_CUSTOMER_PRODUCTS_ALL — references this table through SYSTEM_ID.
• CS_LINE_INST_DETAILS — references this table through SYSTEM_ID.
• CS_SYSTEM_AUDIT — references SYSTEM_ID, OLD_PARENT_SYSTEM_ID, and CURR_PARENT_SYSTEM_ID.
• CS_SYSTEM_PARTY_LINKS and CS_SYSTEM_SR_LINKS — both reference this table through SYSTEM_ID.