Search Results csi_i_asset_interface




Overview
Explore in AI Chat

Overview

The CSI_I_ASSET_INTERFACE table is an Install Base (CSI) interface table within Oracle E-Business Suite, identified in the ETRM repository as a VALID, standalone table owned by the CSI schema. Its documented description, "Instance Asset Interface," indicates that it serves as a staging and reconciliation structure through which fixed asset information is synchronized with Oracle Install Base instance records. In the EBS architecture, interface tables such as this one typically receive rows from external or upstream processes, expose them to validation and concurrent processing, and then update the corresponding base entities. The table holds 19 documented columns and a single unique index, CSI_I_ASSET_INTERFACE_U1, defined on IA_INTERFACE_ID.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as standalone, meaning it does not participate in the documented foreign key network in a way that would place it as a classic hub or link. Given its interface nature, the most appropriate modeling suggestion is to treat it as a satellite-like staging entity anchored to the instance asset it ultimately references, with INSTANCE_ASSET_ID acting as the semantic link to the CSI_I_ASSETS base table.

Key Information Stored

The table's surrogate primary key and unique business-key candidate is IA_INTERFACE_ID, which uniquely identifies each interface row and is enforced by the unique index CSI_I_ASSET_INTERFACE_U1. The foreign key column INSTANCE_ASSET_ID references CSI_I_ASSETS and ties each interface record to the target instance asset.

Common Use Cases and Queries

Typical use cases center on reconciling Fixed Assets data with Install Base instances, monitoring interface processing status, and diagnosing rows that failed validation. A common reporting pattern joins the interface table to the base asset table on INSTANCE_ASSET_ID, filtering by UPDATE_STATUS to isolate unprocessed rows:

SELECT i.IA_INTERFACE_ID, i.INSTANCE_ASSET_ID, i.FA_ASSET_NUMBER, i.UPDATE_STATUS
FROM CSI.CSI_I_ASSET_INTERFACE i
WHERE i.UPDATE_STATUS IS NULL OR i.UPDATE_STATUS = 'PENDING';

Analysts also reconcile by FA_BOOK_TYPE_CODE to confirm which fixed asset books have been synchronized, and use ACTIVE_START_DATE and ACTIVE_END_DATE to report effective-dated asset associations. Because INST_INTERFACE_ID groups rows under a parent interface transaction, it supports batch-level auditing of a single interface run.

Related Objects

  • CSI_I_ASSETS — The principal referenced table; joined via INSTANCE_ASSET_ID, the documented foreign key target.
  • CSI_I_ASSET_INTERFACE_U1 — Unique index enforcing IA_INTERFACE_ID and supporting efficient single-row lookups.
  • CSI_II_INTERFACE / CSI_INTERFACE tables — Parent instance interface tables commonly associated with INST_INTERFACE_ID.
  • CSI_INSTANCE_ASSETS / CSI_ITEM_INSTANCES — Install Base instance and asset tables supplying INSTANCE_ID context.
  • FA_ADDITIONS / FA_BOOKS — Fixed Assets source tables underlying FA_ASSET_ID and FA_BOOK_TYPE_CODE.
  • CSI Install Base concurrent programs — Processing programs that read this interface table and update UPDATE_STATUS upon completion.