0 Replies Latest reply: Aug 14, 2013 10:47 AM by 1005995 RSS

    customer item cross-refernce

    1005995

      Hi all,


      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..

       

      Thanx In advance

      Sam