My Oracle Support Banner

E-QR: Queries With Data Privacy Turned on Get "You Have Insufficient Access To Retrieve This Data" Sporadically (Doc ID 2875641.1)

Last updated on MAY 30, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.


When Data Privacy for Query Masking is turned on and queries have aggregate functions in them like COUNT, MAX etc., they sporadically fail to run with the below error message:

"You have insufficient access to retrieve this data. (30,15)"


Replication Steps
1. Enable Query Masking from the navigation: Enterprise Component >> Data Privacy Framework >> Query Masking
2. Run full sync with no exclusions.
3. Create a query using VCHR_HDR_STG_EC record and select aggregate function 'Count' on the Invoice field.
4. Run the query multiple times



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.