"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.
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
There are no changes which triggered the reported issue.
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