Custom criteria to hide employees on garden leave from directory view. — 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 to hide employees on garden leave from directory view.

Summary:

We have a requirement to hide employees who are on Garden leave and we have created a custom criteria for the same. Putting the code here:

But when we have added this to the employee role, pages like - My activity center, check-ins, etc. started to fail and didn't load. We don't see the connection between the two, but we need some suggestions on this as to how such a requirement was handled.

Content (please ensure you mask any confidential information):

EXISTS
(select 1
from per_all_assignments_f paaf 
where paaf.person_id = &TABLE_ALIAS.PERSON_ID
and trunc(sysdate) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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