Getting this error message when trying to access a table via Oracle pipeline functions:
ERROR at line 44:
ORA-20004: ORA-20001: ORA-12840: cannot access a remote table after parallel/insert direct load txn
ORA-06512: at "OPO.OPO_PKG_OUTBOUND_INTERFACE", line 3351
ORA-06512: at line 1
As fas as I can tell, this seems to be caused some sort of uncommitted transaction in a parallel DML operation. What I don't know is how to find out what the transaction is or how to commit it or rollback. This is an urgent production problem, so any help would be appreciated.