Person Security Profile For Accessing Employees Who Do Have Any Payroll Relationships Attached (Doc ID 2354421.1)

Last updated on AUGUST 14, 2023

Applies to:

Goal

We have a requirement in the Security wherein HR user-1 from XCorp entity should be able to view the employees who have payroll relationship called "Regular Payroll".

We are able to achieve this by creating a custom role of the HR Specialist role and assign Person Security profile based on AOR.
In "Secure by AOR" option, which is available in the Person Security Profile page, we select scope of restriction as "Payroll" and also assign the same AOR type to the HR user and specify the AOR scope as the actual Payroll i.e XCorp Regular Payroll.

With above security setup, HR user-1 can access XCorp Regular payroll's Employee records in Person management and do not get to see "Confidential Payroll" employees but the issue that HR user-1 is unable to access employees who are not attached to any Payroll.

Tried to modify the Person Security Profile and selected Secure by Custom criteria and used Custom criteria SQL predicate above but it does not fetch employees without payroll relationship.

Simple Test Example (how the application behaves):
Assigning Payroll Representative AOR (Area Of Responsibility) for HR users.

Assigning the Payroll Representative to a HR user and then in the scope of restriction having selected the Payroll name for which the HR user needs to have access to.
As such, -- HR user can now access employees who are assigned to the above selected Payroll -- type > however, -- the requirement is to also show the employees who are Not assigned to any Payroll --....

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.