During the QA cycle, there may be pending or completed processes that are created for testing purpose and are no longer needed in the server. It will nice to have sql scripts that can be used to clean up the database to remove unwanted processes.

To delete all the processes and their related data from the database, please use the following SQL statements:

delete WF_EVENTS

delete WF_AUTO_WORKITEMS

delete WF_MANUAL_WORKITEMS

delete WF_ACTIVITY_INSTS

delete WF_CUSTOM_ATTRS

delete WF_PROC_TRACKINGS

delete WF_LARGE_TEXTS where TEXT_ID in ( select PROC_INST_ID from WF_PROC_INSTS )

delete WF_PROC_INSTS

delete WF_MAIL_DELIVERABLES