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 126.96.36.199.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!