Limitation On The UpdateCommissionDetailStatus Attached Business Rule
(Doc ID 2643541.1)
Last updated on FEBRUARY 28, 2020
Applies to:
Oracle Insurance Policy Administration J2EE - Version 10.2.0.30 and laterInformation in this document applies to any platform.
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
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 |