EGOIJAVA Item Import Failing with Column Error

(Doc ID 2295108.1)

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.

Symptoms

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
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.

STEPS
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


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