My Oracle Support Banner

Performance Issue on Fluid Requisition Catalog Item Search When “Max Rows to Retrieve for “ Is Set to 300. (Doc ID 2739638.1)

Last updated on DECEMBER 23, 2020

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Searching for an item in Catalog with 250 items is taking more than 45 seconds when the "Max rows to retrieve for " is set to 300 in the E procurement Installation options.
 
The issue can be reproduced at will with the following steps:
1. Go to eprocurement requisitoin and click on catalog for items


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.