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

Custom Criteria for Person Security Profile not working as expected

Received Response

Hello everyone,

We are implementing a new Job Role for our client whereby the employee who will have the role will be able to record absences on behalf on a specific population.

The population is as follows:

- Employees with a specific grade (NC)

- Employees belonging to a specific legal entity.

We created a job role (more details to be attached in screenshot) then we added a person security profile to restrict access.

&TABLE_ALIAS.PERSON_ID IN (SELECT papf.person_id, ppf.person_number,paam.legal_entity_id

FROM per_all_people_f papf, per_all_assignments_m paam, per_grades_f pgf, per_grades_f_tl pgft, per_legal_employers ple , per_people_f ppf

Howdy, Stranger!

Log In

To view full details, sign in.


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