I've been running into situations where our application engines are not clearing the temp tables even after process instance has been deleted.
Also, multiple occurrences of the process halting for no reason.
Oracle's workaround is to clear the temp tables and restart the process.
But which temp tables do you clear?
Try this script.
