HRMS Self-Service - Oracle error 1858: java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected has been detected
(Doc ID 2215656.1)
Last updated on AUGUST 05, 2022
Applies to:
Oracle Self-Service Human Resources - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, EIT and SIT
When attempting to access person Extra Information records from Employee Self-Service, after changing the date format preferences, the following error occurs:
Oracle error 1858: java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected has been detected in ValueSet.isIDValid.
STEPS
The issue can be reproduced at will with the following steps:
1. Access user preferences and change date format to e.g, 'yyyy/MM/dd'
2. Go to Employee Self-Service->Extra Information
3. Above error occurs when attempting to display existing records that contain date fields with custom valueset
Changes
User changed the Date format preferences to value like e.g. 'yyyy/MM/dd'
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |