Extract abending with OGG-01740 Oracle GoldenGate Capture For Oracle: Invalid Numeric Data (Doc ID 2208087.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

OGG Extract reports the below Warning:

2016-11-13 11:03:39 WARNING OGG-01740 Invalid numeric data detected and replaced by _CONVERTBADNUMBER. Column LIMIT_CCY_UTILISED_AMT, table OPS$GTPS01.SCBT_T_LIMIT_U
TIL, rowid AAAD0eAAGAACKWgAC/, row length 5, rowdata: F087E7A4: bc 15 f4 4e 15 |...N.|.

2016-11-13 11:09:29 WARNING OGG-01740 Invalid numeric data detected and replaced by _CONVERTBADNUMBER. Column LIMIT_CCY_UTILISED_AMT, table OPS$GTPS01.SCBT_T_LIMIT_U
TIL, rowid AAAD0eAAGAACKWgAC/, row length 5, rowdata: F087E7A4: bc 14 f4 4e 47 |...NG|.

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