Re: Workflow background process errors after 19c upgrade

Posted by ErmanArslansOracleBlog on Feb 08, 2023; 12:29pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Workflow-background-process-errors-after-19c-upgrade-tp11563p11568.html

*What are the values of those bind variables?
--you can gather it from an sql trace (gathered with binds)

*Also please check the target rows using an SQL like the following and investigate the data/and the related workflows with your functional admin.

select * from apps.WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1   --replace the bind values with the bind values of the query...

some additional resources: Diagram of Relationship between Core Workflow Tables (Doc ID 444446.1)

*Are there any other workflow errors that may be related with this one..? --Check these types of things with your functional admin also. ORA-06502 may also be a result (not a cause..). Maybe something related with the workflow (workflow activities) is failing there, and effects that update and makes that update get ORA-06502 due to having improper values in one of its bind variables. -- WF_ITEM_ACTIVITY_STATUSES is used to store the related records that the workflow activities generate.. (as it name suggests --> ITEM ACTIVITY STATUS)