Poor Performance in Product Hub (PIM) When Creating Several Items at Once with Item People Data (EGOIJAVA) (Doc ID 2066735.1)

Last updated on MAY 15, 2016

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
Concurrent: EGOIJAVA - EGO Spreadsheet Java Concurrent Program
Table: EGO_ITEM_PEOPLE_INTF

Symptoms

Encounters a severe performance issue in EGO Spreadsheet Java Concurrent Program (EGOIJAVA) when creating several items at once.
The problem would occur when creating items from Item Catalog or when importing items through WebADI.

A SQL trace of the issue is showing the following statement as offending:
(extract from a TKPROF output for a problematic run)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Go to development manager > Item Catalog > Create Production Items
Give the number of items and enter the items details like item number and description manually
2. Click on Submit
3. EGO Spreadsheet Java Concurrent Program gets launched
4. See the concurrent request is keep on running and taking more than 1 hour


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