Search Results csi_i_party_interface




Overview
Explore in AI Chat

Overview

CSI_I_PARTY_INTERFACE is an open interface table in the Oracle E-Business Suite Install Base (CSI) module. It serves as the inbound staging area for party information associated with install base instances, allowing external source systems, legacy conversions, and third-party applications to load party, contact, and account relationship data before it is validated and transferred into the production Install Base tables. In release 12.1.1 and 12.2.2 the table is owned by the CSI schema and is documented as VALID, containing 111 columns.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is standalone. This suggests the table is best treated as an independent staging or interface entity rather than as a conventional hub, link, or satellite. It does not participate in a dense network of referential constraints; its single documented foreign key points to CSI_I_PARTIES, meaning the interface record carries a reference to the target instance party while remaining a self-contained load unit.

Key Information Stored

The table's surrogate primary key is IP_INTERFACE_ID, which is also the sole documented unique index (CSI_I_PARTY_INTERFACE_U1) and therefore the primary business-key candidate for row-level identification during interface processing. The most significant columns include:

Common Use Cases and Queries

Typical scenarios include legacy data conversion of customer party relationships into Install Base, integration from external CRM or billing systems, and bulk maintenance of account relationships tied to installed assets. Common SQL patterns select unconsumed or errored rows:

  • Identifying failed rows: SELECT ip_interface_id, party_name, error_text FROM csi_i_party_interface WHERE error_text IS NOT NULL;
  • Reviewing staged data by batch: SELECT * FROM csi_i_party_interface WHERE inst_interface_id = :batch_id;
  • Checking load progress by parallel worker: SELECT parallel_worker_id, COUNT(*) FROM csi_i_party_interface GROUP BY parallel_worker_id;
  • Joining to the target party table to confirm successful linkage on INSTANCE_PARTY_ID to CSI_I_PARTIES.

Reporting use cases center on interface reconciliation, validation error analysis, and audit of party relationship effective dates before committing data to production.

Related Objects

  • CSI_I_PARTIES – Referenced through the documented foreign key INSTANCE_PARTY_ID; the production party relationship table populated after interface processing.
  • CSI_I_PARTY_INTERFACE child batch sources via INST_INTERFACE_ID (the instance-level open interface tables) – governs the parent instance interface grouping.
  • Install Base open interface concurrent programs – the standard request set that reads this table, validates rows, and writes results into CSI_I_PARTIES.
  • HZ_PARTIES and related Trading Community Architecture tables – supply and validate party identity referenced by PARTY_ID, PARTY_NUMBER, and PARTY_NAME.
  • HZ_CUST_ACCOUNTS – resolves the account numbers and account relationship types staged in the IP_ACCOUNT*_ID and PARTY_ACCOUNT*_ID columns.