Performance Issue in iSupplier Portal View Payment Page When Searching By Purchase Order Number (Doc ID 1948841.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

In Oracle iSupplier Portal, Release 12.1.3, a performance issue occurs when searching for payments by purchase order number.
It takes over 200 seconds for the results to be displayed when a purchase order number is specified.

It is expected that the results be displayed in a much shorter amount of time.


Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications as a supplier user, using the iSupplier Portal Full Access responsibility.
2. Click the Finance tab.
3. Click the View Payments subtab.
4. On the View Payments page, enter a blanket purchase agreement number in the "PO Number" field, and click the Go button.
The search results take more than 200 seconds to display.


Business Impact

Due to this issue, supplier users lose a lot of productivity while waiting 3-4 minutes for the search results to be displayed every time the search by PO number is performed.



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