Item Import Error troubleshooting steps
Item Import Error Details INV_IOI_MASTER_CHILD Errors in Item Import [ID 429924.1] Post completion of the 'Item Import' Program, all the successfully imported record gets into mtl_system_items_b however all the e rrored out record gets into mtl_interface_errors , Below SQL which joins mtl_interface_errors with mtl_system_items_interface to fetch all the details relevant to the records errored out. SELECT msii . segment1 , mie . column_name , mie . error_message FROM apps . mtl_interface_errors mie , apps . mtl_system_items_interface msii WHERE mie . organization_id = 1417 AND mie . transaction_id = msii . transac...