INCOIN, Item Import Error: Unable To Correctly Update The History Table - Fnd_stats_hist

(Doc ID 1376070.1)

Last updated on JANUARY 21, 2016

Applies to:

Oracle Item Master - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Aug-2014***

Symptoms

When attempting to run Item Import (INCOIN), the following error occurs.

ERROR
-----------------------
TRANSACTION ID : XXXXXX
ORGANIZATION ID : XX
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.
Unable to correctly update the history table - fnd_stats_hist.
-1 - ORA-00001: unique constraint (APPLSYS.FND_STATS_HIST_U1) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Update item master records from the MTL_SYSTEM_ITEMS_INTERFACE table

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