Custom Security Profiles in Oracle HRMS / Oracle HCM

Security profiles are used in Oracle Applications HCM to restrict the information which a user can see. Information can be restricted in many ways e.g., based on Organization, Position, Supervisor etc. One of the disadvantages of this is that these criteria are too generic and may not always meet our requirements. For example, if employee A, who works in Workshop (Welding) is transferred temporarily to Head Office for few days. Now the HR user of Workshop (Welding) can’t see employee A because of security profile based on organization. But due to HR policies, the HR user of Workshop (Welding) should be able to monitor the employee A.

Oracle has given a very flexible option of ‘Custom Security’ while defining the security profiles in which we can define the criteria based on our requirements. This method used SQL syntax and as such is very powerful.

Now coming back to our requirements, we will define a custom security profile which will add employee A to the security profile of Workshop (Welding) even though the employee  is in Head Office. To do this, the main idea is:

1. Navigate to

[HRMS Responsibility] > Security > Profile

2. Define the security profile for the above requirements.

3. The SQL for the same is:

ASSIGNMENT.ORGANIZATION_ID

IN

(121)

OR

ASSIGNMENT.PERSON_ID in (8000)

In the above SQL, the organization_id for Workshop (Welding) is 121 and person_id for employee A is 8000.

4. Once this security profile is built after we run the Security List Maintenance concurrent program, the HR user of Workshop (Welding) will be able to see all the employees of Workshop (Welding) PLUS employee A.

As this is a very powerful feature, which can’t be covered in few pages, I have tried to give a very brief idea of how this functionality works. Based on your requirements, you will have to develop the correct SQL.