Oracle Solution for Error ora-24058

ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

What triggered the Error:

attempt was made to downgrade the queue table when there were messages being propagated that were in the prepared state.

What should we do to fix it:

it for the propagation to complete before retrying the operation.