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. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Person Security Profile with Custom Crtieria not working
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.
Tagged:
0