INCOIN - Fails With CSTPIDIO(7):ORA-01422: exact fetch returns more than requested number of rows
I am trying to Import an Item using the Item Interface(MTL_SYSTEM_ITEMS_INTERFACE) using the Concurrent Job Import Items.
While doing so, I am getting the below-mwntioned error. Item gets created in the Master Org but doesnot get assigned to the Child Orgs. the Item Interface is populated with records for Child Orgs
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Updating CSI ITEM_COSTS
Updating CSI ITEM_COSTS
************************************
TRANSACTION ID : 28648894
ORGANIZATION ID : 394
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME :
MESSAGE NAME : CST_ERR_IN_OI
ERROR MESSAGE : CSTPIDIO(7):ORA-01422: exact fetch returns more than requested number of rows