which oracle version are you using?

what do you get if you execute:

insert into tab1
select /*+ parallel(a,8) */
transcode, filename, rectype, count(*), sum(charge), sum(units)
from recs a
where recs.filename like 'XY%'
group by transcode, filename, rectype