Columns With User Defined Functions Not Captured By Extract In SQLSERVER (Doc ID 2296725.1)

Last updated on AUGUST 15, 2017

Applies to:

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

Symptoms

Replicating Data from MSSQL to ORACLE. There are some columns in the MSSQL defined like below

[bcrm_expectedendtime] AS ([dbo].[fn_UDF_7b216ab21b114132bda0d33ddaf8e1e8]([bcrm_durationtype],[bcrm_tat],[CreatedOn])),

Extract is not capturing the data for these columns after trandata is enabled as well. 

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