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
Last updated on MAY 25, 2018
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'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms