Organization Assignment of an Item thru Interface

We can assign items to an organization thru interface by below steps:

1. Insert selected items in mtl_system_item_interface table.
Select items from some existing organization or from your own custom table.
insert into mtl_system_items_interface(
inventory_item_id,organization_id,set_process_id,process_flag,transaction_type)
select inventory_item_id, organization_id,786000,3, 'CREATE' from mtl_system_items a
where organization_id = 149 and segment1 = '90-02' and segment3 = 'DM'

2. Change organization_id and Organization code as per the new organization
update mtl_system_items_interface
set organization_id = 331,organization_code = 'RPT' where set_process_id = 786000

3. You can change the lot control status or shelf life if it is different than the souce organization
update mtl_system_items_interface
set lot_control_code =2, shelf_life_code =4 where set_process_id = 786000

4. Now change the process code
update mtl_system_items_interface
set process_flag=1

5. Run the item import progamme with create or update items (last parameter in request) 1 (create).
Note: If there is a need to change some attribute after organization assignment you need to enter records again in mtl_system_item interface with updated attributes and then submit the item import program with create or update items (last parameter in request) 2 (Update existing items).