All the process chains are failing due to SQL Error ( SQL Error: ORA-00604: error occurred at recursive SQL level 1) in BIP system.
Root cause: process failed due to SYSTEM Tablespace being full, on detailed analysis we saw a spike in the SYSTEM Tablespace usage which resulted in SYSTEM tablespace full. 
Remediation: extended the SYSTEM table space