My Oracle Support Banner

"ORA-01795: maximum number of expressions in a list is 1000" in Create User When Admin Adds More Than 1000 Customers to One User (Doc ID 2543534.1)

Last updated on APRIL 23, 2023

Applies to:

Oracle FLEXCUBE Direct Banking - Version DB 12.0.3 to DB 12.0.3 [Release DB 12]
Information in this document applies to any platform.

Symptoms

Bank has reached 1000 secondary customers for a single user. When trying to add additional customer, application shows error 'System cannot process request'
Logs show below error :

java.sql.SQLSyntaxErrorException:

ORA-01795: maximum number of expressions in a list is 1000

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.