How to fix the Oracle error JMS-00142: JMS topic must be created in multi-consumer enabled queue tables?

In this post, you’ll learn more about the Oracle ErrorJMS-00142: JMS topic must be created in multi-consumer enabled queue tables with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

JMS-00142: JMS topic must be created in multi-consumer enabled queue tables

Reason for the Error JMS-00142: JMS topic must be created in multi-consumer enabled queue tables

Cause: An attempt was made to create a JMS topic in a single-consumer queue table

How to fix the Error JMS-00142: JMS topic must be created in multi-consumer enabled queue tables ?

You can fix this error in Oracle by following the below steps

Action: JMS topics can only be created in queue tables that are multiconsumer enabled