R12 iSupplier Poor Performance at PO Query For Blanket Agreement Containing Many Lines (Doc ID 1929036.1)

Last updated on JULY 25, 2017

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In 12.1.3
Query for a large blanket agreement in iSupplier gets slow performance or timeout.

NOTE:  A similar issue occurred in 11.5.10.2, and the solution was given per [ Note 1538192.1 - Slow Performance or Timeout for Supplier User at View Order Details for Purchase Order or Blanket in iSupplier Portal (Doc ID 1538192.1) ]. That solution was to apply a patch and also create some indexes manually per advice from Development.

STEPS TO REPRODUCE
1. Identify a blanket agreement having 100 lines or more
2. Open iSupplier Portal External responsibility
3. Click Orders Tab
4. Enter the blanket PO Number and search
5. Click PO link to view details
6. Wait 60 - 300 seconds for the results to display or sometimes see a timeout occurs before the results are shown



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