Item Import Error "DEFAULT_SO_SOURCE_TYPE Attribute column value is not valid"
(Doc ID 2322544.1)
Last updated on AUGUST 24, 2020
Applies to:
Oracle Inventory Management - Version 12.2.5 and laterInformation 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |