I am doing Customer Item and Customer Item Cross Reference Interface using the Import Customer Item and Import Customer Item Cross Reference Interface concurrent program respectively.. I am finding no problem in creating new records using this Concurrent program. But i cant find a way to update the existing records using this program. Do any body know how to do this..
I inserted a record into mtl_ci_xrefs_interface with update as transaction type and wanted to update the existing record in the mtl_customer_xrefs, but when i run the concurrent program it says ORA-00001: unique constraint (INV.MTL_CUSTOMER_ITEM_XREFS_U2) violated. Please let me know if anybody has already done this..