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.
Custom Criteria in the person security profile is not working as expected.
Summary:
Hi Everyone
We have created a person security profile with custom criteria. It is giving expected result when previewing in the security profile but when Data role attached to the user and user logins, goes to person management, it is not giving the expected. I would like to know whether the written query is valid. When i validated the query at the person security profile page, it was valid.
&TABLE_ALIAS.PERSON_ID IN (select paam.PERSON_ID
from per_all_assignments_m paam,
hr_organization_information_f hoif
where 1=1
and paam.effective_latest_change='Y'
and paam.assignment_type = 'E'
Tagged:
0