My Oracle Support Banner

ERS9.1+: In Express Search Page the Sort order is Incorrect with Dates Search, Availability and Qualifications Settings. (Doc ID 2020396.1)

Last updated on OCTOBER 18, 2021

Applies to:

PeopleSoft Enterprise FIN Resource Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.


In Express Search Page the Sort order is incorrect with dates search, availability and Qualifications settings. There are many business cases where would only search on availability for example the pool or resource group is already a defined skill set (interchangeable ie: all DBAs) and just need to see who has availability for a short 3 week assignment.  In this case we would leave qualifications blank and only search based on availability.

On the other side, when search on both qualification and availability it still does not sort correctly.  Logically it should sort those with 100% match on qualification and then within that subset it should sort 100% available at the top. It is not doing that.  The availability are not consistent.
1. Navigation to Search Configuration: set the verity settings and factor weights.
2. Run the cache administration process.
3. In Express Search page: Set the following criteria: start and end date, resource pool, search setting is set for availability=5 while the other search criteria is zero. Click on search for resources.

Actual Result:
In the first 50 records:  mix exists between 42% and  100% and not in a correct order.
Second 50 records: mix exists between 0 and 100 and not in a correct order.
The same happens across all output.

Expected Result:
Resources with 100% availability should be listed first and then resource with less % should be returned in order.

Please see the Replication Steps document for more details related to complete configuration and the Replication Steps necessary to reproduce the issue.


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

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