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.
When the person name is getting updated, the process is failing in the API HR_PERSON_API with the following error:
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:
- Update Employee Name
- Attempt to load a new extract which contains the employees new name.
- 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