Performance Problem With SPF_BID_LOAD

(Doc ID 2346796.1)

Last updated on JANUARY 09, 2018

Applies to:

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

Symptoms

On : 9.2 version, Performance

SPF_BID_LOAD performance problem and occasional errors with results.
Logged in as Service Coordinator - go to Assess and Award Bids page Note: If criteria entered exclude bids with bid scoring issues, performance can be affected and no error is returned.
This is happening with large number of transaction


 
The issue can be reproduced at will with the following steps:
This is impacting the Service Coordinators from the Assess and Award Bids
page.
1 - Log in as Service Coordinator
2 - Go to Services Procurement > Assess and Award Bids
3 - Select Incoming Bids and remove from Date, click Search
4 - Getting a performance issue

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