Oracle Error ORA-24077: cannot create propagation schedule for EXCEPTION queue string.string

Oracle Error Message

ORA-24077: cannot create propagation schedule for EXCEPTION queue string.string

Reason for the Error

A SCHEDULE_PROPAGATION was issued for an EXCEPTION queue. Propagation schedules can be created only for NORMAL queues.

Solution

To propagate messages from a queue specify the queue type as NORMAL.