Web ADI Performance Issue While Updating or Creating Attributes
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
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.
Due to this issue, the program "EGO Spreadsheet Java Concurrent Program" is taking too long to be functional for the business.
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