Custom criteria Person Security Profile- Restricted role users to search particular employees — Cloud Customer Connect
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 Person Security Profile- Restricted role users to search particular employees

edited Oct 15, 2024 2:49PM in Human Capital Management 1 comment

Summary:

Hi,

By using Custom criteria Person Security Profile- we have Restricted role users to search particular employees, but role users are able to search restricted employee through me→ directory.

Any solution to restrict directory search as well.

Code of Person Security Profile-

(EXISTS
(SELECT 1 FROM PER_ALL_ASSIGNMENTS_M ASG,PER_PERIODS_OF_SERVICE PS,PER_ASG_RESPONSIBILITIES RES
WHERE ASG.ASSIGNMENT_TYPE IN('E','C','P','N')
AND ASG.EFFECTIVE_LATEST_CHANGE='Y'
AND TRUNC(SYSDATE) < ASG.EFFECTIVE_END_DATE
AND PS.PERIOD_OF_SERVICE_ID=ASG.PERIOD_OF_SERVICE_ID
AND (ASG.ASSIGNMENT_STATUS_TYPE IN ('ACTIVE','SUSPENDED') OR (ASG.ASSIGNMENT_STATUS_TYPE IN ('INACTIVE')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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