Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Import Items program is failing with Message Name:INV_IOI_ERR and Column Name: INVENTORY_ITEM_ID and

edited Feb 7, 2018 12:35AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center