HCM: Query Data Masking Causes Error In Query Manager "You have insufficient access to retrieve this data."
(Doc ID 2975815.1)
Last updated on SEPTEMBER 26, 2023
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Query Masking is causing the same error in two scenarios:
You have insufficient access to retrieve this data. (30,15)
The issue can be replicated at will with the following steps:
- Navigate to Enterprise Components > Data Privacy Framework > Maintain Data Privacy Settings
- For scenario #1 - Add a field on the JOB record that was not previously marked as Sensitive/PI, such as ANNUAL_RT
- For scenario #2 - Remove the Sensitive/PI checkboxes for an existing field, such as LAST_HIRE_DT field
- Navigate to Enterprise Components > Data Privacy Framework > Query Masking > Run Query Masking Data Sync
- Run the sync in Full mode
- After that is complete, go to Reporting Tools > Query > Query Manager
- Create a new Query using JOB record
- For scenario #1 - use the Annual Rate field in the conditions for the query
- For scenario #2, use LAST_HIRE_DT in the conditions for the query
- Error will be thrown when the user tries to run 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! |
In this Document
Symptoms |
Cause |
Solution |