Custom Security Profile Referencing Lookup is not Dynamically Generated

(Doc ID 1498964.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.


On 12.1.3 version

Security Profile - Not generating dynamic results.

Having set one global security profile which has custom type security (SQL query) where we are using Look up reference in it. The employee number entered in look up decides the permission for manager to employee data.

When the profile is assigned the profile to responsibility it generates the employee list as expected but when the given permissions are removed from Look up it gives following issue,

1. It does not dynamically change the list of employees based upon changes in look up and shows the previously generated employee list.

2. after 20 minutes it shows all the employees (across all BG's)

3. After 2 hours the changes are then reflected.

Expect the changes to be reflected in SSHR in a matter of minutes not hours.

*** Please note ****
This only affects SSHR when the same is performed in the core application the changes are reflected in the expected timeframe.

The issue can be reproduced at will with the following steps:
1. Update a global security profile for it to change permissions.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms