Query Throwing Error: ORA-12801: error signaled in parallel query server P002

query is run on a dataguard database that has database link to another database. when query the table thru the database link alone it runs fine however if used with other queries it throws the ORA-12801 error.

this query runs on a dataguard database that throws the ORA-12801 error:

select cse.district_cd,
       cse.case_number_id,
       cse.case_nm,
       cse.case_type_cd,
       cse.case_status_cd,
       cse.suffix_id,
       hbv.SHELTER_TYPE_CD,
       hbv.HP_SEASON_END_DT DT,
       row_number() over (partition by cse.district_cd, cse.case_number_id, cse.suffix_id order by hbv.HP_SEASON_END_DT desc) rn 
  from wrt_welfare_case cse, 
       wrt_heap_budget_vw hbv, 
       wrt_district_cd dc
 where cse.case_type_cd = '60'
   and cse.case_status_cd in ('10','21')  
   and cse.district_cd != '66' 
   and cse.district_cd = dc.district_cd
   and cse.case_number_id = hbv.case_number_id
   and hbv.district_cd = dc.district_cd_short_txt
   and hbv.shelter_type_cd = '03'
   and hbv.HP_SEASON_END_DT between '01-sep-2022' and '30-sep-2022';