My Oracle Support Banner

Recompile Metadata For Data Removal Tool Fails with ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small (Doc ID 2564161.1)

Last updated on JANUARY 29, 2021

Applies to:

Oracle Compensation Workbench - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP11 version, Compensation Workbench

Recompile Metadata for Data Removal Tool Fails with following error

ORACLE error 20001 in FDPSTP
Cause: FDPSTP failed due to ORA-20001: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PER_DRT_RULES", line 585
ORA-06512: at "APPS.PER_DRT_RULES", line 602
ORA-06512: at line

Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Navigate to PDR Meta Data tool page
2. Choose Product = PER, Schema = 'BEN' Table_name = 'BEN_CWB_PERSON_INFO' and version = choose from whatever is in existence or create new.
3. Add 55+ columns
     - Also Add Custom Flexfield segments or People Group Segments
     - See error above.




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.