FF Adapter 12c Output Format Missing Column Values (Doc ID 2251760.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Application Adapters - Version 11.1.1.1.11 and later
Information in this document applies to any platform.

Symptoms

OGG Flat File Adapter:

***********************************************************************
Oracle GoldenGate Capture
Version 12.2.0.1.160823 OGGCORE_OGGADP.12.2.0.1.0_PLATFORMS_161019.1437
Linux, x64, 64bit (optimized), Generic on Oct 19 2016 16:19:51

***********************************************************************
Started Oracle GoldenGate Adapter for Flat Files
12.2.0.1.5 OGGADP_12.2.0.1.2ADBP_PLATFORMS_161206.1109
***********************************************************************

is not displaying the after image for updates.

EXTRACT is configured with INCLUDEUPDATEBEFORES and GETUPDATEBEFORES

The FF output has the after with extra blank position holders instead of data
"|~^|~^|~^|~^|~^|~^|~^|~":

ERX^|~pvisdb1^|~PRDVIS01^|~28180513318^|~7407364^|~34742^|~AFTE
R^|~54310000005958^|~2^|~U^|~2017-03-25
22:42:37.000000^|~VISION^|~TCT0_RX_IMAGE
^|~0699385149050697118^|~0699385149050697118^|~^|~^|~^|~^|~6993^|~6993^|~^|~^|
~414557906^|~414557906^|~2017-03-26:00:42:51^|~2017-03-26:00:42:51^|~^|~^|~^|~
^|~^|~^|~^|~^|~^|~^|~414557906^|~414557906^|~2017-03-26:00:42:54^|~2017-03-26:
00:42:54^|~^|~^|~^|~^|~^|~^|~^|~

 

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