My Oracle Support Banner

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

Last updated on JANUARY 27, 2021

Applies to:

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

Symptoms

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.




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.