Limitation On The UpdateCommissionDetailStatus Attached Business Rule (Doc ID 2643541.1)

Last updated on FEBRUARY 28, 2020

Applies to:

Symptoms

On : 10.2.0.30 version, Activity

The UpdateCommissionDetailStatus attached business rule cannot update AsCommissionDetail table records if the number of records to update is more than 2500.
The following error occurs.


ERROR
-----------------------
java.lang.RuntimeException: Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
Error Code: 0
Call: SELECT AsTransaction.TransactionName, AsActivity.EffectiveDate, AsCode.ShortDescription
FROM AsActivity JOIN AsTransaction ON AsTransaction.TransactionGuid = AsActivity.TransactionGuid JOIN AsCode ON AsCode.CodeValue = AsActivity.StatusCode AND
AsCode.CodeName = 'AsCodeStatus' WHERE AsActivity.activityGuid IN


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Agent in the system and attach him/her to more than 2500 policies.
2. Process CommissionCalculation on each of these policies.
3. Run any of the client level transactions (i.e PreCommissionStatement or FinalCommissionStatement) that has an UpdateCommissionDetailStatus attached rule.

*** The system would return a java error indicating that there are too many entries to update ***

Cause

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