3649698 - Cannot import date format value in EXR when using enumerated list

When import date value in EXR, the job failed with error message "No value maintained as xx/xx/xxxx in the enumerated list" or the job run successfully but the value does not update in the EXR.

• SAP SuccessFactors Compensation
• SAP SuccessFactors Variable Pay

1. Create column A, check "Set enumerated values", and set column type as Date, fulfill the enumerated element using format "mm/dd/yyyy".
2. Launch worksheet, go to EXR found the format in column A is "dd/mm/yyyy".
3. Export the data in EXR and import the data in column A. Will facing 2 different scenario depends on the import value format:
   a. Using "dd/mm/yyyy" format, the job will fail with error message "No value maintained as xx/xx/xxxx in the enumerated list".
   b. Using "mm/dd/yyyy" format, the job will run successfully, but the import value won't be updated into EXR.

The enumerated list date format is different from the system language. The system storage hardcoded date format in the database, which conflicts with the frontend display format based on the system language.

Use a string type for the column instead of a date type to avoid format conflicts.

date format inconsistency, import failure, import issue, dd/mm/yyyy, mm/dd/yyyy, Enumerated value, compensation, variable pay, date value, import, EXR, executive review, upload date, import date, update date, enumerated list, enumerated, language date format, date format , KBA , LOD-SF-CMP-GDL , Guidelines, configuration, CSV data, etc. , Problem