BOM_PARSE_ITEM_ERROR when Trying To Create Item Through Item Import Interface (Doc ID 1341334.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Item Master - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Item Issues

When attempting to execute the Import Items (INCOIN) process to create new items, the following errors occur.

ERROR
-----------------------
TRANSACTION ID : 563210
ORGANIZATION ID : 92
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME :
MESSAGE NAME : BOM_PARSE_ITEM_ERROR
ERROR MESSAGE :

TRANSACTION ID : -1
ORGANIZATION ID : -1
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME :
MESSAGE NAME : INV_IOI_ERR
ERROR MESSAGE : *** BAD RETURN CODE b ***
Exceptions occurred during Import Item

If the default revision code contains more than one character, then while creating the Item the customer is getting 'BOM_PARSE_ITEM_ERROR' error.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. insert one new row in the mtl_system_items_interface table with transaction_type = 'CREATE'
2. Launch import items (navigation : inventory / items / import / import items)
3. Job completes in ERROR and give messages documented above

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