My Oracle Support Banner

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 SEPTEMBER 28, 2022

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 "ABC: 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




Changes

 

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.