E-SEC: PSACCESSLOG does not Exist in the Access Groups Available to you (29,6) (Doc ID 618552.1)

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.
SPECIFIC TO:
PeopleTools 8.4x

Currency check 27AUG2012




Symptoms

Still have questions after reading this document? Please post a question to our community: PeopleTools Community


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)
etc.

Investigation done:
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.

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