INCOIN, Item Import Error: Unable To Correctly Update The History Table - Fnd_stats_hist
Last updated on JANUARY 21, 2016
Applies to:Oracle Item Master - Version 18.104.22.168 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Aug-2014***
When attempting to run Item Import (INCOIN), the following error occurs.
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
The issue can be reproduced at will with the following steps:
Update item master records from the MTL_SYSTEM_ITEMS_INTERFACE table
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