ERS 9.1/9.2: Incorrect Express Search Results By Resource Group When The Same Resource Group Name Is Configured By Different Users (Doc ID 1558194.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

ISSUE:

Express Search is not displaying the proper results when using Resource Group functionality. This happens when two Users or more have created different Resource Groups but using the same Resource Group ID Name.

The delivered codeline within Application Package PeopleCode RS_MATCHENGINE:RsMatchEngine.OnExecute calls SQL Object RS_XS_GETRSRC_OPT, which contains the following PeopleCode:

SELECT RS_MYRSRC_OPT
FROM PS_RS_RSRCGRP
WHERE RS_RSRCGRP_NAME = :1

Because the above query, used to determine the select option, does not pass the User ID logged into the system and performing the search, as a parameter, the system retrieves the Search Option of a Resource Group with that ID Name, but from the wrong User ID. Therefore, displaying incorrect results.

REPLICATION STEPS:

   - Log into the FSCM Online Application as User ID VP1
   - Navigate to: Set Up Financials/Supply Chain > Common Definitions > Resource Search > Search Configuration
   - Open existing Search Type RSFSR (Express Search/Fulfill Orders), and make sure all the configuration is properly set up
   - Navigate to: Set Up Financials/Supply Chain > Common Definitions > Resource Search > Cache Administration
   - Launch the Cache Administration Application Engine Program (RS_CACHE_AD) for Search Type RSFSR (Express Search/Fulfill Orders), making sure it goes to Success
   - Navigate to: Resource Management > Define User Options > Resource Group Setup
   - Add a brand new Resource Group ID under the name of TEST, select the 'Select By Supervisor ID' option, and define a couple of Employees (KU0042 and RS00000001)
   - Navigate to: Resource Management > Express Search
   - Perform an Express Search by  Resource Group, choosing the Group TEST just created: The results display all the hits of Resources having as HR Supervisor ID the Employees defined (up to 40 results)
   - Navigate to: Resource Management > Manage Resource Pools > Pool Resources
   - Open the existing Pool ID 0000000009 (Global Info Technology), and see how it has listed a total of 7 Resources
   - Log into the FSCM Online Application as User ID VP2
   - Navigate to: Resource Management > Define User Options > Resource Group Setup
   - Add a brand new Resource Group ID, also under the name of TEST, select the 'Select By Pool' option, and define Resource Pool ID 0000000009 (Global Info Technology)
   - Navigate to: Resource Management > Express Search
   - Perform an Express Search by  Resource Group, choosing the Group TEST just created
   - While it is expected to have up to 7 Resources listed as the result of the search (those defined at the Pool ID 0000000009 - Global Info Technology), the system is showing again the same results as if the search had been done using the TEST Resource Group defined by User ID VP1 (Select By Supervisor ID)

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

BUSINESS IMPACT:

The Express Search becomes unreliable and misleading, given the fact that it returns results completely wrong to those expected by the Staffing Coordinator User performing the search. This can result in choosing incorrect Resources for a potential task, and thus not maximizing the efficiency of the company's Resources.

EXPECTED BEHAVIOR:

The system should always consider who is the User ID logged into the system, and when performing an Express Search, not only take into consideration the Resource Group ID selected, but also from which User ID it belong to, so the proper Search Options are applied, and the correct results are displayed.

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