How to combine two person security profile in one data role — Cloud Customer Connect
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

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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