Lazarus reports

Once upon a time, I thought that after a report had run in the Concurrent Manager there was no possible way to run the same request over again.  Time has passed and I have become more powerful than you can possibly imagine, so I now know that the concurrent is just a program reading the values from tables within the data structure.  This meant that it was possible to have reports emerge from the dead like Lazarus (or the Pit of the same name) with this script for 10.2.0.4 on EBS 11.5.10.2:

update fnd_concurrent_requests
set phase_code = 'P', status_code ='Q'
where request_id in ()

After going to 11.2.0.2 without changing from EBS 11.5.10.2, I noticed that my old script wouldn't exactly work the same so after several different investigative attempts the script needed to be tweaked to:

update fnd_concurrent_requests
set phase_code = 'P', status_code ='I'
where request_id in ()

Obviously something like this should be used with care, as restarting certain reports may cause data corruption issues, but if you're reading this blog you should be a responsible adult.  Any irresponsible adults reading, please feel free to keep reading the blog.  :}