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

Person Security Profile with Custom Crtieria not working

edited Sep 13, 2024 5:27PM in Human Capital Management 2 comments

Summary:

Below is the custom criteria of a person sec profile included in the data role for 'Human Resource Specialist'

&TABLE_ALIAS.PERSON_ID IN (SELECT A.PERSON_ID FROM PER_ASSIGNMENTS_F A, HR_ALL_POSITIONS B
WHERE A.POSITION_ID = B.POSITION_ID
AND B.NAME in (
'a specific position name added here'
))

No other conditions added.

When run in SQL interface, the above SQL is resulting with the required rows; also, the person sec profile preview allows to search only the people in this position

The data role added with above person sec profile, added to a person with no other role than EMployee role is allowing to access all people through Person Managmenet (Classic Page) and through RUI Page.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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