Using Taleo to Enter Employees into EBS HCM Causes Error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

(Doc ID 2314298.1)

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.

Symptoms

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.

Error updating Assignment.ORA-06502: PL/SQL: numeric or value error: character to number conversion error




Cause

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