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:

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

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