ORA-01795: When Certification Reviewer Has More Than 1000 Accounts For Review.

(Doc ID 2385267.1)

Last updated on APRIL 18, 2018

Applies to:

Identity Manager - Version 11.1.2.3.5 and later
Information in this document applies to any platform.

Goal

The loadBatchUserEntitlementForXls API returns with the error message " java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 " when the reviewer has to review more than 1000 accounts.

Steps to reproduce:

  1. Create one manager
  2. Create 1001 users and make their managers the manager you just created
  3. Provision to those 1001 users an account
  4. Create a 2 phase User certification for the above users and use as reviewer / the manager
  5. Run the following code as the reviewer against the above certification

Solution

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