After Field Service Debrief with a transaction type style of 'RETURN Material' get Error: 'Multiple Active Instances Found For The Item Attributes Provided'
(Doc ID 337482.1)
Last updated on MAY 22, 2020
Applies to:Oracle Installed Base - Version 11.5.9 to 184.108.40.206 [Release 11.5]
Oracle Field Service - Version 11.5.9 to 220.127.116.11 [Release 11.5]
Information in this document applies to any platform.
After a Field Service Debrief with a transaction type style of 'RETURN Material' and after running the CSF DEBRIEF UPDATE LINES concurrent request, the following error occurs:
Inventory Item ID : 111
Organization ID : 22
Sub-Inventory : SIBINV
Locator ID :
Action: Check for duplicate inventory records found in CSI_ITEM_INSTANCES"
A similar error also is listed in the CSI Transactions Interface table for this item-subinventory combination but this time on a Subinventory Transfer.
CSFUPDATE module: CSF:Update Debrief Lines
The log file shows the same error.
As a consequence, you have several debriefs stuck with this error message and you cannot update Install Base or Inventory.
While the error complains of multiple active instances, when you check in Install Base, you cannot see any duplicate/multiple item instances for the same locator. You can check for possible duplicate instance records by running the following sql:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document