Performance Issue With ICX Queries When Using Item-Related APIs From EGO_ITEM_PUB Package
Last updated on DECEMBER 19, 2017
Applies to:Oracle Item Master - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Oracle Product Hub - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Performance issues occur when using below item-related APIs –
All these APIs seem to be performing poorly when the IProcurement-related queries are executed (iProcurement Product short name=ICX). You see a lot of executions in the trace files related to these causing a huge performance hit to bulk load operations using API.
These APIs are not designed for bulk-load operations. The ICX-related queries in them are executed once for each item created by the API, instead of running once for the complete set of items created.
ICX API will always be executed in concurrent request context, or normal script context, but since ICX API is executed for each item in concurrent request context by INV package (as INV package is defined as seeded concurrent request), it's the cause of the performance issue.
As EGO_ITEM_PUB.PROCESS_ITEMS is not suggested to be executed in concurrent request
You may be seeing below queries taking a lot of time, with multiple executions in the trace file -
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