Searching For Supplier Item In Supplier Item Catalog Is Slow (Doc ID 1406703.1)

Last updated on AUGUST 23, 2016

Applies to:

Oracle Purchasing - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 01-May-2014***

Symptoms


In Oracle Purchasing, users experience delay in display of values for Supplier Item field in Supplier item catalog form.

From SQL trace the following performance issue is observed:

 select distinct(vendor_product_num) supplier_item,
 po_moac_utils_pvt.get_ou_name(org_id) operating_unit, org_id
 from
 po_lines union select distinct(suggested_vendor_product_code) supplier_item,

 po_moac_utils_pvt.get_ou_name(org_id) operating_unit, org_id from
 po_reqexpress_lines order by 1,2


call    count  cpu       elapsed   disk        query     current     rows
------- ------ --------  ---------- ---------- ---------- ---------- ----------
Parse   1      0.20      0.20       1          589        0          0
Execute 1      0.00      0.00       0          0          0          0
Fetch   328    497.54    582.04     93382      94169      0          32767
------- ------ --------  ---------- ---------- ---------- ---------- ----------
total   330    497.74    582.25     93383      94758      0          32767




Steps To Reproduce

1. Search Supplier Item Catalog.
2.  Enter the supplier item.
3. Press Tap
4. Observe that there is a delay up to 7 minutes to find the Supplier item.
-- User are not able to press the Find button until the system has found the number.
5. When the system has found this number, users are able to press the Find button.
-- This means that Supplier Item field in Supplier item catalog form was taking more time to display the values.

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