what do you get with:

select b.*
from
(select /*+ FULL(a) PARALLEL(a, 8) */
transcode, filename, rectype, count(*) cnt, sum(charge) sum_c, sum(units) sum_u
from recs a
group by transcode, filename, rectype) b
where b.filename like 'XY%'