Item category assign ment and onhand quantity for inventory item in R12

THese are the minimum column required for importing item category for an item.
The interface assigns the category for a given item.
The category and item should be predefined for this to work.
If category is not defined then you should create category and find the category id for the created category along with inventory item id.


INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE
(
LAST_UPDATE_DATE --SYSADTE
,LAST_UPDATED_BY --USERNAME
,CREATION_DATE --SYSDATE
,CREATED_BY
,CATEGORY_SET_ID -- category set id in MTL_CATEGORY_SETS_TL
,ORGANIZATION_ID
,INVENTORY_ITEM_ID--INVENTORY ITEM ID
,CATEGORY_ID--SEARCH FROM MTL_ITEM_CATEGORIES
,OLD_CATEGORY_ID--IN CASE OF UPDATE
,PROCESS_FLAG --sud be 1
,TRANSACTION_TYPEp--,'UPDATE'/'create'
,SET_PROCESS_ID --NOTE THIS COLUMN MUST BE ENTERED LIKE BATCH NUMBER
)




ON HAND QUANTITY



insert into mtl_transactions_interface
(
transaction_type_id SOURCE mtl_transaction_types
,transaction_uom
,transaction_date
,organization_id
,transaction_quantity
,last_update_date
,last_updated_by
,creation_date
,created_by
,transaction_mode SHOULD BE 3
process_flag SHOULD BE 1
,source_header_id
,source_line_id
,source_code
,lock_flag SHOULD BE2
,flow_schedule SHOULD BE Y
,scheduled_flag SHOULD BE 2
,transaction_header_id
,inventory_item_id
,transaction_interface_id SOURCE mtl_material_transactions_s.nextval
,subinventory_code
,distribution_account_id
,transaction_reference SHOULD BE 'Migration'
)

cheers!!