CSTPIDIO(7):ORA-01422: exact fetch returns more than requested number of rows
I am running the Import Items after having records in mtl_system_interface table, the item is created in Master Organization, but not assigned to other organizations and the program is erring out with the error message.
TRANSACTION ID : 27910643
ORGANIZATION ID : 481
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
Now, If I exclude the items related to 481 organization and run the Import Items it assigns all the items to all other organizations successfully. Can somebody help me in this? Thank You very much