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.
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:
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.
Apply Eligibility Rule, Error, UI6, USERS_VALUE, invalid identifier , KBA , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , Problem