2194993 - Error - There was an unexpected error during the process: ORA-00904: "UI6" ("U17")."USERS_VALUE": invalid identifier when applying Eligibility Rules - Compensation

SAP Knowledge Base Article - Public

2194993 - Error - There was an unexpected error during the process: ORA-00904: "UI6" ("U17")."USERS_VALUE": invalid identifier when applying Eligibility Rules - Compensation

Symptom

When applying the eligibility rules the UI displays the message There was an unexpected error during the process. Please contact support.

1.jpg

 

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.

2.jpg

Environment

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.

3.jpg

Same applies for any other System field used as Import Key. This is the list of System fields:

 

  • STATUS
     
  • USERID
     
  • USERNAME
     
  • PASSWORD
     
  • EMAIL
     
  • 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.

4.jpg

5.jpg

Keywords

Apply Eligibility Rule, Error, UI6, USERS_VALUE, invalid identifier , KBA , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , Problem

Product

SAP SuccessFactors HCM Suite all versions