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 later
Information in this document applies to any platform.
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'
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
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)
- click 'Upgrade Profile Setup Data'
- refresh > Status error.
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