EGOIJAVA Item Import Failing with Column Error
Last updated on AUGUST 21, 2017
Applies to:Oracle Product Hub - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Catalog items
Item creation via EGO Spreadsheet Java Concurrent Program (EGOIJAVA) fails and items are not seen in the Item Catalog Category (ICC) .
ERROR MESSAGE : The column specified in MTL_INTERFACE_ERRORS.COLUMN_NAME must be specified as either be 'Y' or 'N' in the interface table.
ERROR MESSAGE : The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE.
Inventory Item ID "xxxxxx" is not a valid Inventory Item ID in the passed-in Organization.
The issue can be reproduced at will with the following steps:
1. Run the EGOIJAVA: EGO Spreadsheet Java Concurrent Program
2. Review the errors
3. Note the items are not seen in the item catalog category
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