My Oracle Support Banner

UpdateCommissionStatus BR Reports 'ORA-01795: Maximum Number Of Expressions In A List Is 1000' Message (Doc ID 2783300.1)

Last updated on JUNE 10, 2021

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.2.4.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.4.1 version, General

When attempting to update multiple CommissionDetail with the UpdateCommissionStatus BR,
when there is an update more than 1000 CommissionDetail, the following message is reported:


ERROR
-----------------------
Caused by: com.adminserver.utl.exception.AsExceptionUtl: An error occurred while processing business rule: UpdateCommisionDetailStatus.
at com.adminserver.pas.ape.UpdateCommissionDetailStatusApe.processRule(UpdateCommissionDetailStatusApe.java:168)
at com.adminserver.sre.bll.TransactionBusinessRulePacketRuleBll.processRule_aroundBody4(TransactionBusinessRulePacketRuleBll.java:133)
at com.adminserver.sre.bll.TransactionBusinessRulePacketRuleBll$AjcClosure5.run(TransactionBusinessRulePacketRuleBll.java:1)
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
... 56 more
Caused by: com.adminserver.utl.exception.AsExceptionUtl: Failed to Load CommissionDetail
at com.adminserver.pas.dal.DataRetrieverDal.findCommissionDetailByCommissionDetailGuidList(DataRetrieverDal.java:6084)
at com.adminserver.pas.dal.DataRetrieverDal.retrieveDataDclList(DataRetrieverDal.java:984)
at com.adminserver.pas.dal.DataRetrieverDal.retrieveDataDclList(DataRetrieverDal.java:241)
at com.adminserver.pas.dal.DataRetrieverDal$$FastClassBySpringCGLIB$$39db3697.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
... 63 more
Caused by: com.adminserver.utl.exception.AsExceptionUtl: Database error occurred while performing operation SELECT.
at com.adminserver.dal.jdbc.JdbcDataAccessHelper.executeSelectQuery(JdbcDataAccessHelper.java:114)
at com.adminserver.pas.dal.DataRetrieverDal.findCommissionDetailByCommissionDetailGuidList(DataRetrieverDal.java:6080)
... 81 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use a UpdateCommissionStatus to update more than 1000 CommissionDetails.


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
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.