Oracle Solution for Error ora-31427

ORA-31427: publication string already subscribed

What triggered the Error:

The subscription already contained this publication.

What should we do to fix it:

Check the values of subscription_name and publication_id. Check any other subscribe calls to see if they subscribe to columns that are shared among more than one publication on the same source table. Do not attempt to subscribe to the same publication more than once in the same subscription. Use the publication_id variant of the SUBSCRIBE call if needed to specify precise publications.