BOM_PARSE_ITEM_ERROR when Trying To Create Item Through Item Import Interface

(Doc ID 1341334.1)

Last updated on FEBRUARY 15, 2018

Applies to:

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

Symptoms

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