My Oracle Support Banner

While Updating HR Security Profile, Unable To Save Custom Query In The Custom Security Tab. (Doc ID 2945770.1)

Last updated on APRIL 28, 2023

Applies to:

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

Symptoms

On : 12.1 HRMS RUP8 version, Security Issues

ACTUAL BEHAVIOR
-------------------------------
After updating custom SQL in the Custom Security Tab and saving the changes in the Security Profile details, the values does not save.

EXPECTED BEHAVIOR
------------------------------------
Expect the custom security details to be present after saving the changes.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to 'US Super HRMS Manager” Responsibility -> Security -> Profile
  Query the Security Profile name in use.


2.  Set all values ( View Dropdown values) to Restricted
  Allow Granted Users checked.

3. Click on the Custom Security Tab
  Select 'Restrict the people visible to this profile' from the Drop-down value.
 
4. Make some changes  (Example: PERSON.PERSON_ID = 100) and save
    Re-query the security profile the custom security tab values shows blank. Does not show the above SQL.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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