Extract Trail Shows NULL Values for PK Columns Even When SCHEMATRANDATA Is Enabled

(Doc ID 1479742.1)

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

SCHEMATRANDATA is enabled for the schemas in replication. When Extract is writing to the trail file, the primary key column is showing as NULL.

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