Below is my scenario. We are getting error randomly in production. when we restart the process error disappears. we are not able to reproduce even in lower environment. Can you please help in letting us know the potential issue with insert statement and how do I resolve it. I do not want to remove parallel. Is this anything to do with partitions?

t1 is partitiond on date and subpartitioned on sales_code
t2 is partitiond on date;

         
view_t is built on top of 2 tables like:         
create view view_t as select * from t1 union all select * from t2;
         

insert into t (col1,col2,col3,col4) select * from ( SELECT /*+ PARALLEL(16) */ <<columns>> from  view_t join <<multiple tables joined>> where <<conditions>> ) where <<conditions>>

Error : Getting error -12842 : ORA-12842: CURSOR INVALIDATED DURING PARALLEL EXECUTION