INCOIN Item Import Will Reject Items With INV_IOI_REV_NO_ITEM Error - The revision entered is for an item that does not exist (Doc ID 801354.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle Item Master - Version 11.5.10.0 to 12.1.3.4 [Release 11.5 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:INCOIN - Import Items
This document includes all versions of Oracle EBS 11i and R12 and later


Symptoms

While attempting to create items through Item Import open interface (INCOIN), the records get rejected with the following error in the request log and in MTL_INTERFACE_ERRORS table.
Item revisions are not used.

ERROR
TRANSACTION ID : 837853
ORGANIZATION ID : 1001
TABLE NAME : MTL_ITEM_REVISIONS_INTERFACE
COLUMN NAME : ITEM_ID
MESSAGE NAME : INV_IOI_REV_NO_ITEM
ERROR MESSAGE : The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE.

STEPS
The issue can be reproduced at will with the following steps:
1. Populate the open interface table
2. Launch Item Import

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