Performance Issue With ICX Queries When Using Item-Related APIs From EGO_ITEM_PUB Package
(Doc ID 1486605.1)
Last updated on MAY 21, 2021
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 -
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