How To Delete Process Instance Backend

Let's say you wanted to delete a specific process instance and you want to do it backend. The script below would be helpful specially if you opted to create a script to do things automatically.


This works for Oracle Database with PT 8.49:


DELETE FROM PSPRCSRQST where PRCSINSTANCE = 1220519;
DELETE FROM PSPRCSQUE where PRCSINSTANCE = 1220519;
DELETE FROM PSPRCSPARMS where PRCSINSTANCE = 1220519;
DELETE FROM PSPRCSRQSTTEXT where PRCSINSTANCE = 1220519;
DELETE FROM PSPRCSRQSTXFER where PRCSINSTANCE = 1220519;
DELETE FROM PS_PRCSRQSTDIST where PRCSINSTANCE = 1220519;
DELETE FROM PS_AERUNCONTROL where PROCESS_INSTANCE = 1220519;
DELETE FROM PS_IN_USAGE_AET where PROCESS_INSTANCE = 1220519;