E-QR: Query Advanced Search Shows Queries The User Doesn't Have Access To (Doc ID 1609428.1)

Last updated on JANUARY 04, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.
*** Checked For Relevance On 4-Jan-2016 ***

Symptoms

When attempting to search for queries in advanced search in Query Manager using the Record Name field (e.g. search for queries that use Record Name begins with 'PERS'), the search results will list queries that the user doesn't have access to.
When the users click to edit one of the queries, sometimes the message occurs that "The record (x) does not exist in the access groups available to you.", and other times it kicks the users out to the following error page:

  “An error has occurred.
  You may attempt to sign in again.
If your attempt fails, please contact your System Administrator.
Please make sure Webserver and Appserver are up.null”

Steps
-------
The issue can be reproduced at will with the following steps:
1. Navigate to PeopleTools > Security Permissions & Roles > Permission Lists
2. Create a new permission list (SB_USER_TEST)
3. Go to Query tab and add access to QUERY_TREE_CC > CC ACCESS GROUP under Access Group Permissions
4. Navigate to PeopleTools > Security Permissions & Roles > Roles  
5. Create a new Role (SB_USER_TEST)
6. Go to Permission Lists tab and add your new query permission list (SB_USER_TEST)
7. Navigate to PeopleTools > Security > User Profiles > User Profiles
8. Create a new test user ID (SB_USER_TEST), Password: 'xxxxxxx' with the following roles:
EOPP_USER
PeopleSoft User
PeopleTools
SB_USER_TEST
9. Now log in as your test user ID
10. Navigate to query manager and search for Query Name begins with SCC
11. Notice the query SCC_CHECKLIST is not listed in the results
12. Click Advanced Search and search by the query SCC_CHECKLIST, notice the query SCC_CHECKLIST is not listed in the results
13. On the same Advanced Search page, besides of the "Query Name" (SCC_CHECKLIST) add an additional criteria for "Uses Record Name" begins with PERS. Notice SCC_CHECKLIST is listed in the results
14. Click the Edit link to try to edit SCC_CHECKLIST, and get kicked out to the error page.

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