My Oracle Support Banner

ORA-01795: When Certification Reviewer Has More Than 1000 Accounts For Review. (Doc ID 2385267.1)

Last updated on JULY 21, 2020

Applies to:

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


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


To view full details, 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 a vibrant support community of peers and Oracle experts.