Symptom
When applying the eligibility rules the UI displays the message: There was an unexpected error during the process. Please contact support.
And the email notification indicates an error: DAOException caught: ORA-00904: "UI6"."USERS_VALUE": invalid identifier OR DAOException caught: ORA-00904: "UI7"."USERS_VALUE": invalid identifier.
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
Cause
The template is using the USERID field as an Import Key for a custom field. It is not relevant if the field is used in the eligibility rule, the system validates every field and is not able to apply the rule as USERID is a System Field and as such, unexpected as an Import Key.
Same applies for any other System field used as Import Key. This is the list of System fields:
- STATUS
- USERID
- USERNAME
- PASSWORD
- GENDER
- LASTNAME
- FIRSTNAME
- MI
- MANAGER
- HR
- TIMEZONE
- DEPARTMENT
- DIVISION
- LOCATION
- JOBCODE
- HIREDATE
- COMPANYEXITDATE
- DEFAULT_LOCALE
- NICKNAME
- SUFFIX
- SALUTATION
Resolution
The Import Key needs to be changed. You can create a custom Import Key, for example USERID_1, that will create a new column in the User Data File, and then you can copy the information in the System Field USERID into the Custom Field USERID_1.
Keywords
Apply Eligibility Rule, Error, UI6, USERS_VALUE, invalid identifier , KBA , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , Problem