Using Taleo to Enter Employees into EBS HCM Causes Error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Last updated on OCTOBER 05, 2017
Applies to:Oracle Human Resources - Version 12.2.7 and later
Information in this document applies to any platform.
On : 12.2.2 version, Person / Assignment Issues
We have a program "SGY: Taleo Create Prospective Employees", this will pick the data from Taleo tables and it will create the employee in the HRMS system.
Today, the program has been successfully completed but the employee records are errored status "E" with the below error message.
Error Message : Update Employee Assignment - Error updating Assignment.ORA-06502: PL/SQL: numeric or value error: character to number conversion error
All the employees got same error message. but last week we are able to create the employees by using this program.
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