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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Employees searchable in directory even after securing them using custom criteria in Person Sec Profi

Summary:

We have a requirement to secure few employee which will be marked as 'Restricted' and 'Highly restricted' in Persons Attributes DFF created. For not showing these employees in Directory, we have created a person security profile using custom criteria. The custom criteria is below

&TABLE_ALIAS.PERSON_ID NOT IN (SELECT PP.PERSON_ID FROM PER_PERSONS PP, PER_ALL_ASSIGNMENTS_M ASG WHERE PP.ATTRIBUTE1 IN ('Restricted', 'Highly Restricted') AND PP.PERSON_ID = ASG.PERSON_ID )

In preview screen in person security profile, I am not able to search for these employees.


However when I go to directory from user having a role containing this person security profile, I am able to search for such employees but when I click on them I get ADF error.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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