In the MDM database DEBUG log, do you see any other error, something like this, preceeding this error message (maybe even after):
Autonomous SQL Error (-12801).SQLERRM is: ORA-12801: error signaled in parallel query server P003 ORA-01652: unable to extend temp segment by 128 in tablespace CM
If you see something similar to this, then you need to increase the tablespace.
"ORA-00942: table or view does not exist" is reported for C_PARTY. Please ensure permission on the schema for table and package CMXBV. I think there is some misconnect here.
Please increase tablespace on your ORS schema with the help of your DBA team to resolve this issue.