My Oracle Support Banner

Item Category Assignment Open Interface Creates No Record And Displays No Errors (Doc ID 2113571.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.


The Item Category Assignment Open Interface, after truncating the interface tables, does not process submitted rows, leaves PROCESS_FLAG=1, and does not populate MTL_INTERFACE_ERRORS. This is confirmed by before and after dumps of MTL_ITEM_CATEGORIES_INTERFACE. Log file displays as follows:

Inventory: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

INV_ITEM_CAT_ASSIGN_OI: Item Category Assignment Open Interface

Current system time is 26-FEB-2016 12:56:40


**Starts**26-FEB-2016 12:56:40
**Ends**26-FEB-2016 12:56:40
Item Category Assignment Open Interface import completed successfully for all records in this record set.
Start of log messages from FND_FILE
End of log messages from FND_FILE


1. Patch 20161648:R12.ITM.C was applied to insure the errors table was populated; no change in the problem.

2. Support requested that the insert statement used be modified to match the documentation [ • CATEGORY_SET_ID or CATEGORY_SET_NAME and CATEGORY_ID or CATEGORY_NAME ] instead of supplying both values; customer did so but no change in the problem.

3. Multiple efforts to produce a debug log file do not produce one. Customer reports he has set the debug options as requested and has provided screen shots to confirm same. No debug log is created at the customer site.

Expect Item Category Assignment Open Interface to populate rows accordingly or to throw an informative error message if it fails, as well as to produce a debug log file when requested.

The issue can be reproduced at will with the following steps:
1. Truncate and populate the interface tables with 1 record having required columns and PROCESS_FLAG=1
2. Run the interface.
3. Observe concurrent request reporting success.
4. Observe no records created, PROCESS_FLAG=1, and no errors generated


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.