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

Last updated on MAY 11, 2022

Applies to:

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
"|~^|~^|~^|~^|~^|~^|~^|~":

xxxx^|~xxxx^|~xxxx|~28180513318^|~7407364^|~34742^|~AFTE
R^|~<123344454>^|~2^|~U^|~2017-03-25
22:42:37.000000^|~VISION^|~xxxxxxx
^|~<12334545>^|~<1212343>^|~^|~^|~^|~^|~6993^|~6993^|~^|~^|
~<1232326>^|~<121211106>^|~2017-03-26:00:42:51^|~2017-03-26:00:42:51^|~^|~^|~^|~
^|~^|~^|~^|~^|~^|~^|~<121212323243>^|~<123234r>^|~2017-03-26:00:42:54^|~2017-03-26:
00:42:54^|~^|~^|~^|~^|~^|~^|~^|~

Cause

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