My Oracle Support Banner

Few Updates Made To Boolean Columns In MSSQL Database Were Not Captured By OGG (Oracle Goldengate). (Doc ID 2286628.1)

Last updated on JULY 24, 2017

Applies to:

Oracle GoldenGate - Version to [Release 11.2 to 12.2]
Information in this document applies to any platform.


Using GG version for MSSQL Database , running on windows 2008 R2,

 a column is updated with value from 1 to 0. and the change is captured by extract. When the same column is updated from 0 to 1 extract fails to capture the change.

This filter is being used. is

FILTER ( @EVAL(@AFTER(Encroached_Account_Fl) OR @AFTER(Encroached_Account_Fl) = 0 , 1,@COLTEST(Encroached_Account_Fl, NULL), 1,0)),


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.