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.
How to combine two person security profile in one data role
Summary:
We have a requirement wherein a user can either have a Legal Employer AoR or Department Hierarchy AoR assigned to him or both. The Oracle standard delivered functionality is that these are two separate security profiles. Hence, we created a custom SQL criteria to satisfy the requirement. However, the SQL criteria that we have created is either resulting in a wrong output or is encountering a performance issue (long running). Is it possible to combine 2 security profiles in Oracle? will it work? Below is the SQL criteria that we have created.
(EXISTS(SELECT 1
FROM PER_ALL_ASSIGNMENTS_M ASG,
Tagged:
0