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

Restrict person in directory search result based on DFF value

edited May 11, 2020 11:17AM in Applications Security 2 comments

Summary

Restrict person in directory search result based on DFF value .If DFf value set to 'Yes' ,person should not visible in directory person search result

Content

Hi Team, 

i have configured a Yes/No type DFF segment in Person Information page. 

Based on the DFF value ,restrict person to appear in search result in employee directory.Say, if the value of the segment is 'Yes', then we need the Directory search to exclude those records.

I have created custom security profile with custom criteria  .Attached this custom custom profile with public person security for employee role.

&TABLE_ALIAS.PERSON_ID NOT IN (SELECT PERSON_ID FROM PER_PERSONS WHERE nvl(ATTRIBUTE1, 'N')  = 'Y')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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