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 and later
Information in this document applies to any platform.


On : 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:

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

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


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

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