Item Import Issue

Hi,

I am currently working on Item Conversion, and the requirement is to use the Item Interface table for populating the data and run the item import program. Unique Legacy data will be stored in source_system_id and source_system_reference column in the item interface table. Soon after the item import completed the data was successfully imported to application but value in the source_system_id and source_system_reference column was not captured in the base table MTL_SYSTEM_ITEMS_B.

We are using sequence to create the segment1, unable to track the inventory item id for the newly created items in the custom table and also unable to create item_cross_reference and assign categories for the items.