Is the process flow that has problems active while the package is being deployed? If so this is likely the problem since in workflow the process flow package is replaced with a new version when it is redeployed by OWB, not just the changed process flow(s) within the process flow package. It is best to ensure no process flows in the package being redeployed are executing before redeploying the package.
Thanks for your reply. Yes I agree with your answer but sadly this does not seem to be the cause of the problem in my case as I always stop any running processes and double check with the list_requests.sql as provided and where necessary execute the deactivate_execution.sql and/or abort_exec_request.sql only if absolutely required. Finally I check again with list_requests.sql and if necessary run in the OWF_MGR schema: WF_PURGE.TOTAL and/or the following sql (again only if required) :
FOR cur_rec in (SELECT ITEM_TYPE,ITEM_KEY FROM OWF_MGR.WF_ITEM_ACTIVITY_STATUSES
WHERE ACTIVITY_STATUS = 'ACTIVE')
So I am sure that no processes are running before I begin deployment. Thanks again for your reply.