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 with Redwood for Oracle Cloud HCM   Begin Now

To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

Custom Criteria-security

edited Feb 15, 2023 11:10AM in Human Capital Management 3 comments

Hi Team,

I have a requirement that for the given role human resource specialist have three types of restrictions.

1.Full access of data

2.Excluding HR data (the person who is having this role will not be able to see the employees who belongs to HR department)

3.Restriction of all the data.

Is it possible to provide the above-mentioned access in one role by defining in "Data roles and Security Profiles" using custom criteria.


Iam trying to use the below mentioned code in custom criteria, but it is throwing missing keyword error.

(CASE WHEN PAPF.PERSON_NUMBER = '****' THEN (CASE WHEN PAPF.PERSON_NUMBER IS NULL THEN 0 ELSE NOT IN PD. DEPT = 'DEPT A') END)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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