https://gist.github.com/CedricL46/4462639c6e7c341bd8b0cc5238c07132
Read full tutorial here :...
Read full tutorial here : https://cedricleruth.com/how-to-mass-abort-instances-and-reset-your-oracle-soa-bpel-environment/ - ResetOracleSoaBpelEnvironnement.sql
read full tutorial