2371908 - Compensation Management: “A non-numeric character was found where a numeric was expected” error when applying Eligibility Rules

After applying the eligibility rules, the following error displays:

“There was an unexpected error during the process. Please contact Support.”

The e-mail notification also displays an error message:

“Form Template Name: #####

 Eligibility Rules cannot be applied because of error: com.successfactors.jobscheduler.ScheduledJobExecutionException: com.successfactors.compensation.util.exception.CompensationEJBException: Exception while CompMiscUtil.applyEligRule: ; nested exception is:

                com.successfactors.sca.service.ServiceLegacyRollbackException: Wrapped Exception: DAOException caught: DAOException caught: ORA-01858: a non-numeric character was found where a numeric was expected.”

SuccessFactors Compensation Management

This issue is caused by an incorrect value in the User Directory File for any of the fields that were used in the Eligibility Rules. For example, if the eligibility rule is configured to use a custom date field and there’s a text value for any user for this field, this error will occur. 

To resolve the issue, you just need to export the User Directory File for the compensation template, remove/correct the invalid values in the for the fields being used by the eligibility rules and import the User Directory File back to the system. 

KBA , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , Problem