My Oracle Support Banner

Update Person Name Which Uses HR_PERSON_API Ending in Error ORA-06502 (Doc ID 2745529.1)

Last updated on NOVEMBER 01, 2023

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.


Problem Statement:

When the person name is getting updated, the process is failing in the API HR_PERSON_API with the following error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

The error message from per_ri_b_errors is as below:

"ORA-06512: at "APPS.HR_PERSON_API", line 1100
"ORA-06512: at "APPS.PER_RI_B_MERGE_WORKER", line 4248
"ORA-06512: at "APPS.PER_RI_B_MERGE_WORKER", line 4432



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Update Employee Name

  2. Attempt to load a new extract which contains the employees new name.
  3. Process errors.




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

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