Last updated on FEBRUARY 04, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
Currency check 27AUG2012
Customer is unable to run 'Review Security Information' reports, Access Activity by User and Access Activity by Day. The navigate to PeopleTools->Security->Review Security Information and attempt to run Access Activity by User or Access Activity but get the following errors.
Received the following error:
[Open Query] [CQryStmt::Prepare] QDM could not load query definition [ PUBLIC.PT_SEC_ACCESSLOG_USER ]
Got the following message in a Message Dialog
The record (PSACCESSLOG) does not exist in the access groups available to you. (29,6)
1. Checked if PSACCESSLOG is accessible in any Query Access Tree and determined it is not available under potential access trees; QUERY_TREE_PT, QUERY_TREE_ALL etc
2. Did a global search for PSACCESSLOG in the system through the Find->Find Record Dialog and found no references.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms