Workflow background process errors after 19c upgrade

Posted by satish on Feb 07, 2023; 4:33am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Workflow-background-process-errors-after-19c-upgrade-tp11563.html

Dear Erman,

We have upgraded 12c EBS database to 19c. Workflow background process erroring out with below error.

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

PLSQL concurrent programs are running fine. Issue not with UTL FILE DIR.

In test instance,the program completing normal. We verified and found there is additional event set in production


Production:
========

SQL> show parameter event; NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
event                                string      10995 trace name context forev
                                                 er, level 16, 10946 trace name
                                                  context forever, level 845414
                                                 4


TEST:
=====

SQL> show parameter event; NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
event                                string      10946 trace name context forev
                                                 er, level 8454144


Can you please gudie what can be done?

Thanks,
Satish