My Oracle Support Banner

Extract writes NULL in trail record for ADT columns (Doc ID 2659521.1)

Last updated on MAY 26, 2020

Applies to:

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

Symptoms


- INTEGRATED EXTRACT (IE) IS WRITING NULL VALUE IN TRAIL FOR ADT COLUMN. BUT ARCHIVED LOG HAS NON-NULL DATA.
- Any ADT columns populated from a view is showing up as NULL in trail file.

- Issue was specific to Integrated Extract and Classic extract was generating trail records correctly.

 

Cause

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
Symptoms
Cause
Solution
References


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