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 later
Information in this document applies to any platform.
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.
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
User changed the Date format preferences to value like e.g. 'yyyy/MM/dd'
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