Error ‘IOI error(s) occurred, but no records found in MTL_INTERFACE_ERRORS table’ When Updating Item Status (Doc ID 1965803.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Receiving error when updating item status

When trying to update item status in Advanced Product Catalog (APC, also known as Product Information Managment (PIM) and Product Data Hub (PDH)), either via WebADI upload or directly in PIM html pages or in Oracle java forms, receive following error message:

‘IOI error(s) occurred, but no records found in MTL_INTERFACE_ERRORS table’

Via WebADI upload: Receive 'Concurrent request number nnnnnn is successfully launched; nn rows successfully uploaded'.
But when checking the log file of the items that were uploaded, it says it completed successfully for both Master organization (org) and Validation org; but clearly the Validation org is not updating.

Via manual method in HTML PIM form: receive the error ‘IOI error(s) occurred, but no records found in MTL_INTERFACE_ERRORS table’ when updating item status for validation Org. Master Org update of item status works fine.

ERROR
-----------------------
‘IOI error(s) occurred, but no records found in MTL_INTERFACE_ERRORS table’

NOTE Similar error may be seen when using API, see
Note 1526495.1 - When Updating Item using EGO_ITEM_PUB.Process_Items See Message IOI Error(s) Occurred, But No Records Found In MTL_INTERFACE_ERRORS Table Item Update Status: U
for a different resolution.

 

Changes

 

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