After looking at the issue on first instance on error code ORA-12801 and parallel clause - then you must refer to parallel processing, at the final result it would consolidate the result (either sorting) using temp ==> so maps to ORA-06152
So that's how link travels from ORA-12801 => ORA-01652.
So, now we need to understand why parallel QC (query co-ordinator raised an exception). I don't want to jump for temp space, set the below event and re-run for additional information for parallel
ALTER SYSTEM SET EVENTS '10397 trace name context forever, level 1';
Now, this event enables me to suppress the and it would wait to get the real error underneath the QC -> Parallel slave which is hitting the problem.