EGOIJAVA WebADI Category Import Fails In Warning But No Details, Missing Error Details [Video]

(Doc ID 1969084.1)

Last updated on JANUARY 02, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Creating a bad catalog category assignment fails but provides the user no details when importing from Excel Advanced Product Catalog concurrent program "EGO Spreadsheet Java Concurrent Program" (EGOIJAVA).

[[INLINE_MOVIE:1969084.1:MOVIE:300:400:MP4]]

 

-- What is working --
The program correctly completes in Warning status but shows no details to user on what went wrong.

ERROR

Example from log:

EXPECTED BEHAVIOR
The concurrent program log or report output error messages should list details about the failure.
Expect row inserted into MTL_INTERFACE_ERRORS.

STEPS
1. Navigate to Dev manager > Batch Import > Import Items > Import from Excel : Choose Item Category
2. Enter Excel details with invalid category.
3. Upload
4. Run the "EGO Spreadsheet Java Concurrent Program" (EGOIJAVA)
5. Report ends in warning.
6. See no errors.

BUSINESS IMPACT
Unable to easily find out which data (item, category, organization etc) was wrong.

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