Profile Upgrade Error: ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small
(Doc ID 2655381.1)
Last updated on JULY 11, 2020
Applies to:
Oracle Fusion Profile Management Cloud Service - Version 11.13.20.01.0 and laterInformation in this document applies to any platform.
Symptoms
The mapping of the custom content and custom fields have been done to respective fields and flex-fileds.
The 'Upgrade Profile Setup Data' process is ending up in error with the error 'numeric or value error: character string buffer too small'
ERROR
-----------------------
Create DFF started at: 2020-04-20 07:18:28
Error occured in procedure HRT_PROFILE_UPG.create_dff . Error Message :
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Logged in s HR Administrator
- My Client groups > profiles
- Manage profile upgrade mapping
- Include in upgrade > check all content types (seeded & custom mapped)
- Next
- click 'Upgrade Profile Setup Data'
- refresh > Status 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 |