Item Import Error "DEFAULT_SO_SOURCE_TYPE Attribute column value is not valid"

(Doc ID 2322544.1)

Last updated on NOVEMBER 07, 2017

Applies to:

Oracle Inventory Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Other Inventory Issues

When attempting to create item by interface
the following error occurs.

ERROR
-----------------------
TRANSACTION ID : 214729
ORGANIZATION ID : 204
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : DEFAULT_SO_SOURCE_TYPE
MESSAGE NAME : INV_INVALID_ATTR_COL_VALUE
ERROR MESSAGE : Attribute column value is not valid.
************************************
TRANSACTION ID : 214730
ORGANIZATION ID : 204
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.
Validation errors occured during Import Item
Refer to table MTL_INTERFACE_ERRORS to access validation errors


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Populate data into MTL_SYSTEM_ITEMS_INTERFACE table

2.Run item import program

Inventory->Items->Import items

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