Symptom
When applying eligibility rules for Compensation template there is an error message:
Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: com-successfactors.compensation.util.exception.CompensationEJBException:
Exception while CompMiscUtil.applyEligRule: ;nested exception is: com.successfactors.sca.service.SetviceLegacyRoIIbackException:
Exception: DAO Exception caught: DAOException caught: Rule: Last Increase, SQL Exception: [314]: numeric overflow: search table error: [6944] exception 70006944: AttributeEngine: overflow in numeric calculation At com.successfactors.compensation.service.schedulejob.CompApplyEligRuleJob.executeJob(CompApplyEligRuleJob.java:159)
**Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental**
Environment
- SAP SuccessFactors Compensation
- SAP SuccessFactors HXM Suite
Reproducing the Issue
When applying eligibility rules from Plan Setup > Plan Details > Eligibility, the job details show an error message as well as the below message within the UI.
Cause
This is due to employee data being incorrectly formatted.
In most cases, when you define these rules for EC or non-EC employees the problem can be caused by the date fields being used.
Resolution
Should you encounter this error message while applying eligibility rules please check all employee data and ensure the fields being used are correctly formatted.
For example, within the UI for non-EC rules you set a hire date to be = 12/30/2019 however in the UDF an employee's hire date can be 30/12/2019 or in order invalid formats like 30.12.2019.
When using EC business rules check the rule conditions against employee data in people profile.
See Also
2085255 - Custom/Standard date field format - Compensation
Keywords
70006944, CompApplyEligRuleJob, table search error, numeric overflow, compensation rule failure, ec rule failure, rules fails, , KBA , LOD-SF-CMP , Compensation Management , Problem