Too Many Where Clauses When Trying To Define Security Profiles (Doc ID 1558574.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion HCM Common Architecture - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.5.0.0 version, HCM Common

When attempting to create or update the Person security profiles, in some instances, able to add multiple criteria without any issues , while in some of the cases , the following error occurs.

ERROR
-----------------------

Error
The security profile cannot be created or updated because the maximum WHERE predicate length supported by data security grants was exceeded. (PER-1531350)
Reduce the number of security criteria defined in this security profile.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as user : ruth.postle
2. Navigate to task : Define Person Security Profile
3. Create/update a person security profile : DW_LIFESCIENCE_DEPT_ADMIN_PERSON_PROFILE, as following ,
  > Include related contacts
  > Restrict workforce structures by department using profile DW_LIFESCIENCE_DEPT_ADMIN_ORG_PROFILE
  > Restrict Positions by Position using profile DW_LIFESCIENCE_DEPT_ADMIN_POSITION_PROFILE
  >> this works

4. Create/update a person security profile : DW_OPS_DEPT_ADMIN_PERSON_PROFILE, as following ,
  > Include related contacts
  > Restrict workforce structures by department using profile DW_LIFESCIENCE_DEPT_ADMIN_ORG_PROFILE
  > Restrict Positions by Position using profile DW_LIFESCIENCE_DEPT_ADMIN_POSITION_PROFILE
  >> this errors out with the error message.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot enforce the required security access in the implementation and impacting Go-Live which was scheduled on 1st May.

Cause

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