CSI_TXN_MULT_INST_FOUND - Multiple active instances found for the item attributes provided

(Doc ID 1118993.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Installed Base - Version 11.5 to 12.0.0 [Release 11.5 to 12]
Information in this document applies to any platform.
***Checked for relevance on 10-Jul-2016***


When attempting to process transactions to Installed Base, the following error occurs.

Multiple active instances found for the item attributes provided.
Inventory Item ID : XXXXXX
Organization ID : 9.990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E+125
Sub-Inventory :
Locator ID : 9.990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E+125
Action: Check for duplicate inventory records found in CSI_ITEM_INSTANCES


Error Description - The error message means that when the API looked to Installed Base for an Instance to update, it found more than one instance that met the criteria from Inventory.  This generally occurs with Non-Serialized Item Numbers (even if they are Serialized at Sales Order Issue).  It can occur for most transaction types including the following most common types:

CSIWIPCI – WIP Component Issue
CSIWIPCR – WIP Component Return
CSISOSHP - Sales Order Shipment
CSIRMARC - Return Material Authorization
CSIWIPAC - WIP Assembly Completion


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms