Performance Problem When Querying Approved Supplier List for an Item
Last updated on APRIL 02, 2017
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
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