Item Category Assignment Open Interface Is Not Uploading Data, Process_Flag = 4

(Doc ID 1243124.1)

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


Symptoms

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.

Expected Behavior
Expect the Item Category Assignment Open Interface to populate the mtl_item_categories table when no error present.

Steps
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

Cause

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