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 AUGUST 26, 2019
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