My Oracle Support Banner

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 07, 2021

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’
 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.