FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise

Symptoms


When you add a subscription to an Oracle transactional publication or an Oracle snapshot publication in SQL Server 2014 or 2016, you receive the following error message:

A publication must have at least one article before a subscription to it can be created.
The subscription could not be found.
Changed database context to 'distribution'. (Microsoft SQL Server, Error: 14124)

Resolution


This issue is fixed in the following cumulative update for SQL Server:

    Cumulative Update 5 for SQL Server 2016 RTM

    Cumulative Update 2 for SQL Server 2016 SP1
  
About cumulative updates for SQL Server

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.