INV_ICOI_MISS_CAT_NAME Item Category

Hi ,

I have one existing Item Category and now i want yo create another?

INSERT INTO mtl_item_categories_interface

( category_set_id

,category_id

,last_update_date

,ORGANIZATION_CODE

,process_flag

,inventory_item_id

,old_category_id

,transaction_type

,set_process_id

)

VALUES

( 1200017     -- category_set_id

,6150            -- new category_id

,SYSDATE

,'ABC'           -- ORGANIZATION_CODE (should be master_orgaization_id if category set is controlled at master level)

,1               -- always 1

,123456         -- Item name  Note: for performance consideration use inventory_item_id in place of item_number

,NULL           -- old category_id

,'UPDATE'

,111             -- set_process_id can be any positive number