My Oracle Support Banner

E-QR/SEC: Access Log Queries Add "WHERE OPRID =" Clause to SQL in PeopleTools 8.40 - 8.45 (Doc ID 623471.1)

Last updated on APRIL 04, 2025

Applies to:

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

This document was previously published as Customer Connection Solution 200773128




Symptoms

In PeopleTools 8.40 - 8.45, under menu path PeopleTools > Security > Common Queries > Access Log Queries > Access Activity by Users and Access Activity by day is only showing the user who logged in and not all users. The query is putting a "Where OPRID =" in the SQL. This should be changed as this is used for auditing and does no good to put a where clause in the query.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.