Oracle Error ORA-32816: foreign queue string is referenced by a subscriber or schedule

Oracle Error Message

ORA-32816: foreign queue string is referenced by a subscriber or schedule

Reason for the Error

An attempt was made to unregister a foreign queue currently referenced by one or more subscribers or propagation schedules.

Solution

Remove all subscribers and propagation schedules using this foreign queue and retry the operation.