ERS 9.2: Getting Error "SQL error in Exec. (2,280) RS_MATCHENGINE.RsReverseSearch.OnExecute" In Staffing Workbench - Manage Utilities, While Searching for Resources
(Doc ID 3043664.1)
Last updated on AUGUST 29, 2024
Applies to:
PeopleSoft Enterprise FIN Resource Management - Version 9.2 to 9.2 [Release 9]PeopleSoft Enterprise FIN Staffing Front Office - Version 9.2 and later
Information in this document applies to any platform.
Symptoms
Getting below error on SQL Error on Staffing Workbench - Manage Utilities, while searching for resources
SQL error in Exec. (2,280) RS_MATCHENGINE.RsReverseSearch.OnExecute Name:calcAvailability PCPC:38703 Statement:575
Called from:RS_MATCHENGINE.RsMatchEngine.OnExecute Name:getResultSetChunk Statement:78
Called from:RS_MATCHENGINE.RsMatchEngine.OnExecute Name:getResultSet Statement:63
Called from:RS_SEARCH.RsRevSearch.OnExecute Name:RevSrchLoadData Statement:155
Called from:RS_MYSERVICEORDERS.GBL.RS_MYRSRCS_WRK.SEARCH_BUTTON.FieldChange Statement:48
Steps:
1. Go to Resource Management > Staffing Workbench - Manage Utilities
2. Select the Search option/setting and select Resource Group Name
3. Select a Resource Clink on Request for selected resource Icon
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 |
| References |