Search Results csi_ip_accounts

Overview

The CSI_IP_ACCOUNTS table is a core data object within the Oracle E-Business Suite (EBS) Install Base (CSI) module. It serves as the definitive association table linking installed product instances to specific customer accounts, which are represented as party accounts in the Trading Community Architecture (TCA) model. Its primary role is to manage and persist the business relationships between an asset (instance) and the financial or service accounts responsible for it. This association is critical for downstream processes in Service, Contracts, Order Management, and Financials, enabling accurate billing, service entitlement validation, and customer asset reporting.

Key Information Stored

The table's structure is designed to capture the multifaceted nature of an account relationship for an instance. The primary identifier is the IP_ACCOUNT_ID. The core foreign keys define the association: INSTANCE_PARTY_ID links to the instance party record in CSI_I_PARTIES, and PARTY_ACCOUNT_ID links to the customer account in HZ_CUST_ACCOUNTS. The RELATIONSHIP_TYPE_CODE (referencing CSI_IPA_RELATION_TYPES) classifies the nature of the association, such as "Bill To" or "Ship To." Furthermore, the table stores specific site uses via BILL_TO_ADDRESS and SHIP_TO_ADDRESS columns, which are foreign keys to HZ_CUST_SITE_USES_ALL, providing granular address-level linkage for transactional purposes.

Common Use Cases and Queries

A primary use case is determining all accounts associated with a specific installed asset for service contract validation or billing. For example, to retrieve the bill-to account for an instance, a common query pattern would join through CSI_IP_ACCOUNTS to the TCA customer tables. Reporting on customer asset portfolios also relies heavily on this table to list all instances linked to a given PARTY_ACCOUNT_ID. From a data integrity standpoint, the table is often referenced in scripts to validate or clean up account associations during data migration or consolidation projects. A typical diagnostic query would select instance details alongside their related accounts and relationship types.

Related Objects

The table is centrally connected to several key EBS entities through documented foreign key relationships:

• CSI_I_PARTIES: Joined via CSI_IP_ACCOUNTS.INSTANCE_PARTY_ID. This is the foundational link to the installed product instance.
• HZ_CUST_ACCOUNTS: Joined via CSI_IP_ACCOUNTS.PARTY_ACCOUNT_ID. This connects the instance to the TCA customer account.
• CSI_IPA_RELATION_TYPES: Joined via CSI_IP_ACCOUNTS.RELATIONSHIP_TYPE_CODE. This provides the meaning (e.g., Owner, Serviced By) for the association.
• HZ_CUST_SITE_USES_ALL: Joined via CSI_IP_ACCOUNTS.BILL_TO_ADDRESS and SHIP_TO_ADDRESS. These links specify the operational addresses for billing and shipping.
• CSI_IP_ACCOUNTS_H and CSI_T_PARTY_ACCOUNTS: Both reference CSI_IP_ACCOUNTS.IP_ACCOUNT_ID. The former is a history table, and the latter is a transactional interface table, highlighting this table's role in audit trails and data integration.