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.
On : 12.2.5 version, OTL Setup forms.
When attempting to run 'Generate Flexfield and Mapping Information', the following error occurs.
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
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'
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