My Oracle Support Banner

Invalid NUMERIC Value: nnnnnn.nnnnnnnn (Doc ID 2862901.1)

Last updated on APRIL 17, 2023

Applies to:

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


While replicating to Google BigQuery we are facing Invalid NUMERIC errors.

gg.handler.bigquery.adjustScale=true  parameter is also used.

=ERROR 2022-01-04 10:25:02.000267 [main] - Error executing batch for target table ORDERDETAIL
=ERROR 2022-01-04 10:25:02.000283 [main] - id: null location: unitprice message: Invalid NUMERIC value: 5766258.4307999993 reason: invalid
=ERROR 2022-01-04 10:25:02.000307 [main] - id: null location: message: reason: stopped
Exception in thread "main" oracle.goldengate.util.GGException: Error detected handling operation added event.
  at oracle.goldengate.datasource.UserExitDataSource.addOperationToTransactionAndFireEvent(
  at oracle.goldengate.datasource.UserExitDataSource.createOperation(
  at oracle.goldengate.datasource.UserExitDataSource.createOperation(

GG BIG DATA : Oracle GoldenGate for Big Data Version (Build 002)


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

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