My Oracle Support Banner

Unable To Add Transactions With An Already Created Incomplete ERS Loan (Doc ID 1594435.1)

Last updated on JULY 10, 2020

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

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
pmt_sch.terms_sequence_number Installment_Number,
pmt_sch.CUSTOMER_TRX_ID invoice_id,
pmt_sch.TRX_NUMBER invoice_number,
pmt_sch.customer_id cust_account_id,

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

at oracle.jdbc.driver.TTIoer.processError(
at oracle.jdbc.driver.TTIoer.processError(
at oracle.jdbc.driver.8Oall.processError(

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.




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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