Assign Inventory Items to an Organization through 'Import Items'
Product R12.1.3.
Assign Inventory Items (Already created / Uploaded and existing in Master Items)to a newly defined Inventory Organization through uploading to 'mtl_system_items_interface' and then executing 'Import Items'.
It used to work fine before. But this time it is not working and all items are rejected with same error-message "The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE".
This is SQL Script:
---------------------------
select
a.set_process_id, --> Value = 1
a.organization_id,--> Correct ORG_ID
a.segment1 , --> Item Code (Existing in Mater Items)