My Oracle Support Banner

Performance Problem When Querying Approved Supplier List for an Item (Doc ID 2250787.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Purchasing - Version 12.0.0 and later
Information in this document applies to any platform.


When querying the Approved Supplier List for an item, the result appears only after more than one minute which is very slow performance.

TKPROF Trace indicates the following statement to be consuming most of the time:


Steps to reproduce:

1. Using a Purchasing responsibility, navigate to Supply Base> Approved Supplier List
2. Go on the menu >View >Query By Example > Enter the entire item number
3. The result appears only after more than one minute



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

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