Search Results csi_i_asset_interface_u1

Overview

CSI.CSI_I_ASSET_INTERFACE is the Open Interface (interface) table used by the Oracle E-Business Suite Install Base Open Interface to stage records that link item instances to Fixed Assets. It is a child table of CSI_INSTANCE_INTERFACE, joined through the INST_INTERFACE_ID column, and is classified within the CSI product under the business entity CSI_ITEM_INSTANCE. In Oracle EBS 12.1.1 and 12.2.2, the table has a status of VALID, is owned by the CSI schema, and resides in the APPS_TS_TX_DATA tablespace with a PCT FREE of 10. Records entered here are processed by the Install Base Open Interface concurrent programs, which validate and import instance-asset associations into the production Install Base tables.

The heuristic Data Vault classification for this object, mined from its foreign key structure, is standalone. In practice, the table behaves as an interface staging entity whose natural business key candidates are the unique index CSI_I_ASSET_INTERFACE_U1 on IA_INTERFACE_ID. Because the classification is standalone, no upstream hub or link dependencies are enforced through foreign keys in the documented metadata; referential integrity is managed by the import programs rather than by database constraints.

Key Information Stored

The table contains 19 documented columns, of which the following are the most functionally significant:

• IA_INTERFACE_ID — Surrogate primary key, unique number identifying the asset interface record. Defined by the unique index CSI_I_ASSET_INTERFACE_U1 (APPS_TS_TX_IDX).
• INST_INTERFACE_ID — Foreign-key-style linkage to the parent CSI_INSTANCE_INTERFACE record; also indexed by CSI_I_ASSET_INTERFACE_N1.
• INSTANCE_ASSET_ID — Sequence number identifying the unique asset-instance link; indexed by CSI_I_ASSET_INTERFACE_N2.
• INSTANCE_ID — The item instance to which the asset is attached; indexed by CSI_I_ASSET_INTERFACE_N3.
• FA_ASSET_ID — Unique number identifying the Fixed Asset; indexed by CSI_I_ASSET_INTERFACE_N4.
• FA_ASSET_NUMBER — Fixed Asset number used to identify the unique asset.
• FA_BOOK_TYPE_CODE — Fixed Asset book type code.
• FA_LOCATION_ID — Fixed Asset location where the asset resides.
• ASSET_QUANTITY — Quantity of assets attached to an item instance.
• FA_SYNC_FLAG — Determines whether Fixed Assets integration should synchronize quantity when interfacing.
• UPDATE_STATUS — Asset status used by the interface processing logic.
• ACTIVE_START_DATE / ACTIVE_END_DATE — Effective date range of the asset association.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit and concurrency columns.

Common Use Cases and Queries

The primary use case is loading asset-instance associations into Install Base via the Install Base Open Interface. Extraction and reconciliation queries typically join the child table to its parent interface table and to Fixed Assets:

• Listing all pending asset links for a given instance interface batch: SELECT * FROM csi.csi_i_asset_interface WHERE inst_interface_id = :p_id;
• Reconciling staged records against imported Install Base assets using INSTANCE_ASSET_ID and INSTANCE_ID.
• Auditing Fixed Asset synchronization decisions by querying FA_SYNC_FLAG, FA_BOOK_TYPE_CODE, and UPDATE_STATUS.
• Diagnosing interface failures or duplicates through the unique index CSI_I_ASSET_INTERFACE_U1 and non-unique indexes N1–N4.
• Reporting assets awaiting import by filtering on ACTIVE_START_DATE and ACTIVE_END_DATE.

Related Objects

• CSI.CSI_I_ASSETS — Referenced by CSI_I_ASSET_INTERFACE.INSTANCE_ASSET_ID; provides the canonical asset definition.
• CSI.CSI_INSTANCE_INTERFACE — Parent interface table, joined via INST_INTERFACE_ID.
• CSI.CSI_ITEM_INSTANCE — Target production table for imported instance records (INSTANCE_ID).
• CSI.CSI_II_ASSET_ATTRS and CSI.CSI_II_RELATIONSHIPS — Supporting Install Base interface structures processed alongside asset links.
• FA.FA_ADDITIONS, FA.FA_BOOK_CONTROLS, and FA.FA_LOCATIONS — Fixed Assets tables referenced through FA_ASSET_ID, FA_BOOK_TYPE_CODE, and FA_LOCATION_ID.
• Install Base Open Interface concurrent programs — The processing APIs that consume records from this table and move them into production Install Base tables.