This discussion is archived
4 Replies Latest reply: May 19, 2011 12:29 AM by user12863742 RSS

Importing Items using Items Open Interface

591457 Newbie
Currently Being Moderated
Hi ,

I am creating items using Items Open interface program. I have populated the data in the MTL_SYSTEM_ITEMS_INTERFACE. Itemcode, oganization, primary_uom and template id and getting the following error.

************************************
TRANSACTION ID : 18739
ORGANIZATION ID : 103
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.
************************************

Item is not revision control and them same is in the template also. still system is giving this error. Whats needs to be done.

Regards/Prasanth