Import Items program is failing with Message Name:INV_IOI_ERR and Column Name: INVENTORY_ITEM_ID and
Hi ,
I am trying to import item through Interface table. After populating mtl_system_items_interface submitted "Import Items" program
"Import Items" program is ending with error.
I checked the error table MTL_INTERFACE_ERRORS and found below values in columns
Message_Name:INV_IOI_ERR and Column_Name: INVENTORY_ITEM_ID and Error_Message : NULL
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Import Items
--------------------------------------------------------------------------------
Argument 1 (ORG_ID) = 136
Argument 2 (ALL_ORG) = 1
Argument 3 (VAL_ITEM_FLAG) = 1
Argument 4 (PRO_ITEM_FLAG) = 1
Argument 5 (DEL_REC_FLAG) = 1
Argument 6 (PROCESS_SET) =
Argument 7 (MODE) = 1
Argument 8 (Gather Stats) = 1
--------------------------------------------------------------------------------
************************************
TRANSACTION ID : 36670843
ORGANIZATION ID : 118
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE