Purge Obsolete Workflow Runtime Data Completes With: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
(Doc ID 415826.1)
Last updated on FEBRUARY 12, 2019
Applies to:Oracle Workflow - Version 18.104.22.168 to 22.214.171.124 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 31-MAR-2012
-- Problem Statement:
Purge Obsolete Workflow Runtime Data process completes in Error. The following error is in the
character string buffer too small
ORA-06512: at "APPS.WF_CORE", line 63
ORA-06512: at "APPS.WF_PURGE", line 1899
ORA-01436: CONNECT BY loop
-- Steps To Reproduce:
Run "Purge Obsolete Workflow Runtime Data" from the System Administrator responsibility with the
item key = null
age = 14
persistence type = temp
core workflow only = no
commit frequency = 500
-- Business Impact:
We need to purge old workflows to keep up performance.
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