Last updated on AUGUST 21, 2016
Applies to:Oracle Item Master - Version 12.1.1 and later
Information in this document applies to any platform.
Executable:INV_ITEM_CAT_ASSIGN_OI - Item Category Assignment Open Interface
Find when running the Item Category Assignment Open Interface, the data is not getting updated in the mtl_item_categories table. When looking at the process_flag for the processed records in the MTL_ITEM_CATEGORIES_INTERFACE table, found that the process_flag get set=4.
There is no corresponding record entry in the mtl_interface_errors table for the processed records.
Expect the Item Category Assignment Open Interface to populate the mtl_item_categories table when no error present.
The issue can be reproduced at will with the following steps:
1. Populate mtl_items_categories_interface
2. Run Item Category Assignment Open Interface
3. View results
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms