Need help in Item Category Assignment Open Interface. We have populated MTL_ITEM_CATEGORIES_INTERFACE table. for UPDATE and CREATE transaction type.
When we try to run Item Category Assignment Open Interface it's not picking any records. log file says it has processed all records but no change in process_flag in interface table.
No records in MTL_INTERFACE_ERRORS table_name='MTL_ITEM_CATEGORIES_INTERFACE' not sure where the problem is let us know if you have any hint on this.
Parameters for Item Category Assignment Open Interface are
Record Set ID: 1, Upload Processed Records:Yes, Delete Processed Records: Yes.
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
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?