Search Results csi_t_txn_systems




Overview
Explore in AI Chat

Overview

The CSI_T_TXN_SYSTEMS table is a core transactional data structure within the Oracle E-Business Suite Install Base (CSI) module for versions 12.1.1 and 12.2.2. It serves as the primary repository for system-level details associated with service transactions. When a transaction is processed in Install Base—such as the creation, update, or movement of an instance—this table captures the overarching system context and related party information. Its role is to provide a comprehensive linkage between a transaction, the customer's organizational structure, and the specific sites and contacts involved in the service event, ensuring accurate tracking and reporting of asset deployments and service relationships.

Key Information Stored

The table's primary key is TRANSACTION_SYSTEM_ID, which uniquely identifies each system record within a transaction. The most critical data stored pertains to customer and site relationships, as evidenced by its foreign key constraints. Key columns include CUSTOMER_ID (linking to HZ_CUST_ACCOUNTS), and various site use identifiers: SHIP_TO_SITE_USE_ID, BILL_TO_SITE_USE_ID, and INSTALL_SITE_USE_ID. Furthermore, it stores references to multiple contact points within the HZ_PARTIES table, such as SHIP_TO_CONTACT_ID, BILL_TO_CONTACT_ID, TECHNICAL_CONTACT_ID, and SERVICE_ADMIN_CONTACT_ID. This structure allows a single transaction to be associated with the complete commercial and logistical footprint of the customer system involved.

Common Use Cases and Queries

A primary use case is generating detailed service transaction reports that include customer location and contact details. For instance, to list all transactions for a specific customer with their installation site address, a query would join CSI_T_TXN_SYSTEMS to HZ_CUST_SITE_USES_ALL and HZ_PARTY_SITES. Another common scenario is validating data integrity during transaction processing or migration by checking for orphaned records where a TRANSACTION_SYSTEM_ID has no corresponding parent transaction line in CSI_T_TXN_LINE_DETAILS. Support personnel frequently query this table to identify the technical and service administration contacts for a system involved in an active service request, enabling efficient communication.

Related Objects

The table is centrally connected to several key EBS objects. It is a child of CSI_T_TXN_LINE_DETAILS via the foreign key on TRANSACTION_SYSTEM_ID, establishing the core transactional hierarchy. Its extensive integration with Oracle Trading Community Architecture (TCA) is critical, with foreign keys to HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES, and HZ_PARTIES. This design ensures that all system details are anchored to the official, shared customer and party definitions used across the EBS suite. Developers typically interact with this table through the standard Install Base transaction APIs, which manage the creation and validation of these records, rather than via direct DML operations.