Unable To Add Transactions With An Already Created Incomplete ERS Loan
Last updated on JANUARY 11, 2017
Applies to:Oracle Loans - Version 12.1.3 and later
Information in this document applies to any platform.
Facing problems while adding new Transactions with an already created Incomplete ERS Loan.
You created one ERS Loan with 2,000 Transactions and the loan created without any issues.
But when the Loan is in Incomplete status, you attempt to add more transactions on the top of the 2,000 transactions and receive the following error:
You have Encountered and unexpected error. Please contact the system administrator for assistance
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in
a list is 1000
Steps to Reproduce:
1. Create an ERS loan with 1005 invoices and save - no errors
2. After the loan is saved, try to add 1 more invoice, the page errors with the same error.
When the Transaction number is less, then it is working fine.
For example suppose the Loan is created with 10 transactions and after creation in incomplete status we have added 15 Transactions with it. This is working absolutely fine.
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