Oracle Error ORA-12842: Cursor invalidated during parallel execution

Oracle Error Message

ORA-12842: Cursor invalidated during parallel execution

Reason for the Error

The cursor was invalidated during the parse phase of deferred parallel processing, e.g. when set operands are parallelized.

Solution

Depends on why the cursor was invalidated. Possible causes include DDL on a schema object and shared pool being flushed.