My Oracle Support Banner

Generate Flexfield And Mapping Information Errors ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2380034.1)

Last updated on OCTOBER 28, 2020

Applies to:

Oracle Time and Labor - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, OTL Setup forms.

When attempting to run 'Generate Flexfield and Mapping Information', the following error occurs.

ERROR
-----------------------
ORACLE error 6502 in FDPSTP
Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.HXC_CREATE_FLEX_MAPPINGS", line 2310


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new element
2. Add the element to existing OTL Element Set
3. Also, add the element to the Alternate Name Definition
4. Run 'Generate Flexfield and Mapping Information' by selecting the appropriate element set and with 'Delete Definitions' parameter as 'No'


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
Cause
Solution
References


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