ERS 9.1: Express Search Qualification % Always Calculated To 0 For Keywords With Special Characters (Doc ID 2043970.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

ISSUE:

While using the Verity Software related feature of Express Search within the FSCM Resource Management module, the Qualification % column gets always calculated as 0% if the User sets special character values in the Keywords criteria field. Even though there are in the system Employees whose uploaded resumes contain the proper values used in the Keywords search, these Resources do not get properly listed in order of Qualification % because special characters are contained in the search string, and resumes uploaded.

The matching results for such Express Search tests provide incorrect results, which prevent Staffing Coordinators to find the best suited candidates for particular projects.

REPLICATION STEPS:

   - Have an FSCM Environment properly configured for Resource Resume processing through Verity Search functionality
   - Log into the FSCM Online Application as User ID VP1
   - Navigate to: PeopleTools > Utilities > Administration > URLs
   - Open the existing URL RS_RESUMES
   - Make sure it has the complete URL for the FTP Server configured for resume files
   - Navigate to: Set Up Financials/Supply Chain > Common Definitions > Resource Search > Search Configuration
   - Open Search Type RSFSR
   - At the Verity Settings tab, make sure to properly configure the navigation for the fields: Style Files, and Resume Files
   - Create a Word document with some data in it, including the wording such as: C++, .Net, or C# (special characters)
   - Navigate to: Resource Management > Maintain Resource Profiles > Profiles
   - Open Employee ID RS00000001
   - Go to the Work Experience tab
   - Upload into the Resource Profile the Word document created previously, by clicking the ADD RESUME button, and save the changes
   - Navigate to: Set Up Financials/Supply Chain > Common Definitions > Resource Search > Cache Administration
   - Create a new Run Control ID, under Source RS, to make sure that the Verity Search Index files are anew created for Search Type RSFSR (Express Search/Fulfill Orders), and run the process to success
   - Navigate to: Resource Management > Express Search
   - At this level, enter the below search criteria:
        - Start Date = December 15th 2014
        - End Date = December 19th 2014
        - Hours per Day = 8.00
        - Keywords = C++
        - Resource Pool = Y
        - Pool ID = 0000000009
        - Personnel Status = All
        - Availability = 3 - Important
        - Qualification = 5 - Much more important
        - Preferences = 0 - Not at all important
   - Click on the 'Search For Resources' button
   - From the list of potential results, Employee ID RS00000001 is displayed, though with a Qualification % of 0%, while it should be 100% instead

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

BUSINESS IMPACT:

The Express Search functionality does not seem to handle properly any special characters included in its Keywords search, and that may be included into the Resources' resume files. As a result, the company is loosing revenues on potential contracts and projects for which no candidates have been found, even though they exist in the system, and may be both available and qualified to perform the tasks at hand.

EXPECTED BEHAVIOR:

Special Character values should be properly handled by the Keywords search feature within express Search, and Qualification % should be calculated accordingly, to reflect the true nature of the company's eligible and qualified Resources.
 

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