Oracle Error Message
ORA-30927: Unable to complete execution due to failure in temporary table transformation
Reason for the Error
In memory temporary tables we create are aged out of shared pool before we are able to grab them again.
Solution
Reduce activities that use a lot of shared pool space or wait for a while, then retry.