My Oracle Support Banner

Web ADI Performance Issue While Updating or Creating Attributes (Doc ID 2066452.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Oracle iProcurement - Version 12.2.3 and later
Oracle Product Hub - Version 12.2.3 and later
Information in this document applies to any platform.
LONG RUNNING :ICX: POPULATE_ICX_ENDECA.SQL
Performance issue in ICX_ENDECA_UTIL_PKG.populate_metadata

Symptoms

In Oracle Product Hub, along with Oracle iProcurement, Release 12.2.3.

In Web ADI, there is a performance issue while updating or creating attributes.
Running Web ADI jobs in PIM to update the UDA attributes in master/child organizations and the program "EGO Spreadsheet Java Concurrent Program" is running for hours for a small set of 2000-2500 records.

It is expected that creating/updating attributes should complete in a reasonable amount of time.


Steps to Reproduce

The issue can be reproduced at will by running Web ADI jobs in PIM to update the UDA attributes in master/child organizations.


Business Impact

Due to this issue, the program "EGO Spreadsheet Java Concurrent Program" is taking too long to be functional for the business.



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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.