Replicat applies NULL Values when Replicating SQL Server Bit Data Type To Oracle Number Data Type

(Doc ID 1576077.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.3 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.1.0.3 version,
ACTUAL BEHAVIOR
---------------
When replicating SQL Server bit datatype to Oracle Number datatype, the value on the target replicated as null

EXPECTED BEHAVIOR
-----------------------
Target Oracle database should not have null value. It should match with value of source column

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms