My Oracle Support Banner

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 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)
- Next
- 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

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