ORA-01795: When Certification Reviewer Has More Than 1000 Accounts For Review.
Last updated on APRIL 18, 2018
Applies to:Identity Manager - Version 184.108.40.206.5 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:
- Create one manager
- Create 1001 users and make their managers the manager you just created
- Provision to those 1001 users an account
- Create a 2 phase User certification for the above users and use as reviewer / the manager
- Run the following code as the reviewer against the above certification
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