You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HCM Extracts - Using Secure Views in Data Group Filter Criteria

Accepted answer


Queries around secured views in data group filter criteria

Content (required):


We have an HCM extract to fetch demographic and payroll information. The extract has a non-mandatory custom parameter tied to a value set. If the user does not select any value, we'd fetch the data across all the legal entities.

The root data group, is PER_EXT_PAY_EMPLOYEES_UE. I was looking at restricting data based on the user's roles in the extract by adding a secured view, here PER_ASSIGNMENT_SECURED_LIST_V to the data group filter criteria.

When I do it using the SQL for PER_EXT_PAY_EMPLOYEES_UE via a BI query, the data is restricted based on the user's roles. However, when we do it via filter criteria, the extract still pulls in all the data regardless of the security offered by the view.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!