E-SEC : Delivered Security Queries do not reflect PeopleSoft Administrator Role access (Doc ID 2194035.1)

Last updated on OCTOBER 18, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.40 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

Security queries access does not return users having access to Application Designer through role "PeopleSoft Administrator".

PT_SEC_APPDES_OBJECTS_USERS
PT_SEC_MENU_USERS
PT_SEC_PTLS_USERS
PT_SEC_REN_USER
PT_SEC_USER_APPDES_ACCESS
PT_SEC_USER_CREF
PT_SEC_USER_CREF_MENU_CMP_MKT
PT_SEC_USER_CREF_PORTAL
PT_SEC_USER_CRF_PRT_MN_CMP_MKT
PT_SEC_USER_PAGE
PT_SEC_USER_PTACCESS
PT_SEC_USER_ROLE_PLIST_PAGE
PT_SEC_USER_SIGNON_TIME
PT_SEC_USER_WS_OP

ERROR
--------------
No matching rows were found (50,200)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Log into PIA
2) Go to Reporting Tools > Query > Query ManageR
3) Enter query name " PT_SEC_USER_APPDES_ACCESS " in the search field and select Edit
4) Then go to Run tab
5) Enter an user id which has PeopleSoft Administrator role in the search field to replicate the issue

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