This content has been marked as final. Show 5 replies
set_process_id was different from 1 (Record Set ID: 1) usually it should be same as that of record Set ID in parameter.
After modification Item Category Assignment Open Interface has processed records
may be the categoy_id and category_set_id is not available in mtl_categories_b,mtl_category_sets_b
if u want to define ur own category ....go to front end
you have to define the valid combination/s (if multiple segments) for the categories and enable them before you are trying to import.
Form navigation is INV>>SETUP>>ITEMS>>CATEGORIES>>CATEGORY CODES
Is there any way to load the valid values without entering them 1 at a time in the form?
I have 5000 values and even dataloader that will take over an hour and is possible to get errors.
Any ideas for importing thousands of category codes?
From the back end change the PROCESS_FLAG value to 1 in the MTL_ITEM_CATEGORIES_INTERFACE table. Then re-run Item Category Assignment Open Interface. This should work.