Goldengate extract may abend with the error OGG-01028  Formatting error on. Source Context : SourceModule            : [er.redo.ora] SourceID                : [/scratch.local/mmar/view_storage/mmar_14516066/oggcore/OpenSys/src/app/er/redo/oracle/redoora.c] SourceFunction          : [REDOORA_handle_format_error SourceLine              : [8949] 2016-03-30 18:13:34 ERROR   OGG-01028  Formatting error on: table name SIEBEL.S_CONTACT, rowid AABjIBAAgAAC/svAAL, XID 12.16.3440952, position (Seqno 7643, RBA 541369824). Invalid numeric data detected. Error converting numeric from Oracle to ASCII on column X_DUP_ID_SEQ, raw length 1, raw data: 02184FD0: 4e |N|.

Add the below parameter in your extract file and start the extract. TRANLOGOPTIONS _INFINITYTOZERO TRANLOGOPTIONS _CONVERTBADNUMBER ZERO