INCOIN Fails With Error INV_IOI_ERR ON ENI_OLTP_ITEM_STAR
Last updated on SEPTEMBER 15, 2016
Applies to:Oracle Product Hub - Version 220.127.116.11 and later
Oracle Item Master - Version 18.104.22.168 and later
Information in this document applies to any platform.
Executable:INCOIN - Import Items
Another related error message: APP-FND-01934: ORA-00001: unique constraint (ENI.ENI_OLTP_ITEM_STAR_U3) violated in Package ENI_ITEMS_STAR_PKG Procedure INSERT_ITEMS_IN_STAR.
When attempting to process Items through the Import Items (INCOIN) Concurrent Process, the following error occurs.
The issue can be reproduced at will with the following steps:
1. Insert item records into the MTL_SYSTEM_ITEMS_INTERFACE table (MSII)
2. Navigate: Inventory > Items > Import > Import Items
3. Launch Import Items
3. Error occurs in the program log file
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms