My Oracle Support Banner

"java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000" Exception Observed On Prospect Search In GBFP FP -> Main Tab (Doc ID 2419172.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

After searching the prospect based on "prospect name" & "prospect ID" in Main Tab, prospect details are not appearing on screen in FP>Main Tab. Below exception is observed in the logs:

java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Changes

There are no changes which triggered the reported issue.

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.