ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

we have 128GB of TEMP tablespace, when running a concurrent program(BA HR Pay Changes Audit Limited Requirement Report) this fails aftr running for 2 hours with error (ORA-01652: unable to extend temp segment by 128 in tablespace TEMP). Tried running the same program in DEV and UAT instance as well == same behaviour

Tried flushing the SQL_HASH_val from shard pool == no go

SQL> select ADDRESS, HASH_VALUE from gv$SQLAREA where SQL_Id='37byhdgcsy6t0';

ADDRESS HASH_VALUE
---------------- ----------
000000016340CD30 3650034464

SQL> exec DBMS_SHARED_POOL.PURGE ('000000016340CD30, 3650034464', 'C');