Re: Workflow background process errors after 19c upgrade

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

Dear Erman,

Thanks for the update.

We have removed the event.

SQL> sho parameter event

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
event                                string      10946 trace name context forev
                                                 er, level 8454144


As advised, We have enabled trace and found below sql statement.

The following statement encountered a error during parse:

UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = :B7 , ERROR_NAME = :B6 , ERROR_MESSAGE = :B5 , ERROR_STACK = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1

Error encountered: ORA-06502
********************************************************************************



Log File:
=====

+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDWFBG: Workflow Background Process
+---------------------------------------------------------------------------+
Current system time is 08-FEB-2023 11:26:24
+---------------------------------------------------------------------------+

**Starts**08-FEB-2023 11:26:24
**Ends**08-FEB-2023 11:26:25
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.

Output file size:
0

Output is not being printed because:
The print option has been disabled for this report.
Deleting empty output file.

SQL> select count(*) from apps.WF_ITEM_ACTIVITY_STATUSES;

  COUNT(*)
----------
  44070140


With same number of records,the program completes normal in test instance.

Please advice.

Thanks,
Satish