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.


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
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


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