Search Results csi_instance_interface_u2

Overview

CSI.CSI_INSTANCE_INTERFACE is the open interface (staging) table for the Oracle E-Business Suite Install Base Open Interface. It holds inbound records for item instances together with their pricing attributes and organization assignments, prior to validation and import into the Install Base repository. The table is owned by the CSI (Installed Base) schema, resides in the APPS_TS_INTERFACE tablespace, and is classified under the business entity CSI_ITEM_INSTANCE. In ETRM terms, its lifecycle is active and its scope is public, making it the standard staging surface through which external systems, legacy conversions, and upstream Oracle modules feed instance data into Install Base in both 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the metadata's heuristic classification for this object is standalone. This reflects its nature as a transient interface staging object rather than a persistent modeled entity: it is neither a hub, link, nor satellite, though functionally it behaves as a combined staging surface that later resolves into the Install Base hub (instance) and its associated link and satellite structures during the import process.

Key Information Stored

The table contains 245 documented columns. The most significant include:

• INST_INTERFACE_ID — Surrogate primary key for each interface row, enforced by unique index CSI_INSTANCE_INTERFACE_U1. This is the sole documented unique index column and therefore the primary business-key candidate at the interface level.
• SOURCE_SYSTEM_NAME — Identifies the originating system, validated against CSI_INTERFACE_SOURCES. Paired with TRANSACTION_IDENTIFIER in unique index CSI_INSTANCE_INTERFACE_U2 as a composite external identifier.
• TRANSACTION_IDENTIFIER — The CSI transaction identifier used to correlate an inbound transaction across interface rows and source systems.
• PROCESS_STATUS — Controls the processing lifecycle of each staged row; indexed by CSI_INSTANCE_INTERFACE_N3 and central to all pending/error/processed queries.
• SOURCE_TRANSACTION_DATE / SOURCE_TRANSACTION_TYPE — The date and type associated with the inbound transaction; SOURCE_TRANSACTION_DATE is indexed by CSI_INSTANCE_INTERFACE_N1.
• INSTANCE_ID / INSTANCE_NUMBER / INSTANCE_DESCRIPTION — The target instance identifier, functional user key, and description of the item instance being loaded.
• INVENTORY_ITEM_ID / SERIAL_NUMBER / LOT_NUMBER / QUANTITY / UNIT_OF_MEASURE — Core instance identification and quantity attributes.
• INSTANCE_STATUS_ID — Foreign key to CSI_INSTANCE_STATUSES, defining the instance status.
• INSTANCE_OU_ID — Foreign key to CSI_I_ORG_ASSIGNMENTS, representing the organization assignment for the instance operating unit.
• PRICING_ATTRIBUTE1..100, PRICING_FLEX_ATTRIBUTE1..15 — Descriptive flexfield-style pricing attribute segments carried with the instance.
• PARALLEL_WORKER_ID — Assigned when instances are loaded via the parallel worker process; indexed by CSI_INSTANCE_INTERFACE_N6.
• ERROR_TEXT — Populated when a staged row fails validation or import.
• INSTANCE_ATTRIBUTE1..30 — Instance-level descriptive attributes.

Common Use Cases and Queries

The primary use case is loading item instance data through the Install Base Open Interface. Implementations insert or load rows into this table, then run the import concurrent program, which validates and moves accepted rows into the Install Base schema while rejecting failures back with ERROR_TEXT.

• Checking pending and error rows: SELECT INST_INTERFACE_ID, SOURCE_SYSTEM_NAME, TRANSACTION_IDENTIFIER, PROCESS_STATUS, ERROR_TEXT FROM CSI.CSI_INSTANCE_INTERFACE WHERE PROCESS_STATUS = 'ERROR';
• Correlating a source transaction across interface rows: SELECT * FROM CSI.CSI_INSTANCE_INTERFACE WHERE TRANSACTION_IDENTIFIER = :p_txn AND SOURCE_SYSTEM_NAME = :p_source;
• Reporting inbound volume by source and date, using indexes N1 and N4: SELECT SOURCE_SYSTEM_NAME, TRUNC(SOURCE_TRANSACTION_DATE), COUNT(*) FROM CSI.CSI_INSTANCE_INTERFACE GROUP BY SOURCE_SYSTEM_NAME, TRUNC(SOURCE_TRANSACTION_DATE);
• Monitoring parallel worker distribution via PARALLEL_WORKER_ID (index N6) when the parallel worker process is used.

Because pricing attributes and organization assignments are staged alongside the instance, the table also supports verification and reconciliation reporting for those elements prior to import.

Related Objects

• CSI.CSI_INSTANCE_STATUSES — referenced by INSTANCE_STATUS_ID; provides valid instance statuses.
• CSI.CSI_I_ORG_ASSIGNMENTS — referenced by INSTANCE_OU_ID; supplies organization assignment records.
• CSI.CSI_INTERFACE_SOURCES — validates SOURCE_SYSTEM_NAME.
• CSI.CSI_ITEM_INSTANCE — the Install Base entity into which validated rows are imported (business entity CSI_ITEM_INSTANCE).
• CSI.CSI_ITEM_INSTANCE_PRICING_ATTRIBUTES — target for staged pricing attribute data.
• CSI.CSI_I_ORG_ASSIGNMENTS / CSI_ORG_ASSIGNMENTS — targets for staged operating unit assignments.
• Install Base Open Interface concurrent programs (CSI) — the processing APIs and programs that consume this table.

In summary, CSI.CSI_INSTANCE_INTERFACE is the principal staging surface for Install Base instance loads, anchored by the INST_INTERFACE_ID surrogate key and the TRANSACTION_IDENTIFIER / SOURCE_SYSTEM_NAME composite business key, with foreign keys to instance statuses and organization assignments.