Performance Issues Occurring in the Buyers Work Center When Querying Agreements by Supplier Name

(Doc ID 1993541.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.
PoHeadersSummaryVO.xml
PoHeadersSummaryVOImpl.java
poact.odf
popo.odf
DocumentConstants.java
SearchSvrCmd.java

Symptoms

Performance is slow while query Agreements in Buyer Work Center(BWC) by providing the Supplier name. When searching for an Agreement for a specific supplier it can take more than 1 minute to retrieve only one record.

If the query is made for a supplier having multiple agreements, the system runs for more than 10 minutes without actually retrieving the data and thentimes out-getting Internal Server Error 500.

Steps to reproduce:


1. Login to a Purchasing Responsibility

2. Navigate to: Buyer Work Center > Agreements tab

3. Go to Search

4. Enter the Supplier Name as query criteria and click Gthe "GO" button

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