How to fix the Oracle error ORA-31487: cannot support begin dates or end dates in this configuration?

In this post, you’ll learn more about the Oracle ErrorORA-31487: cannot support begin dates or end dates in this configuration with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31487: cannot support begin dates or end dates in this configuration

Reason for the Error ORA-31487: cannot support begin dates or end dates in this configuration

The specified values cannot be used in a Distributed HotLog configuration.

How to fix the Error ORA-31487: cannot support begin dates or end dates in this configuration ?

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

Remove the specified values from the CREATE_CHANGE_SET CDC API call.