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

Last updated on APRIL 02, 2017

Applies to:

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

Symptoms

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

 

Cause

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