My Oracle Support Banner

Veridata Trimming Decimal Part From The Value causing table OOS (Doc ID 2412550.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle GoldenGate Veridata - Version and later
Information in this document applies to any platform.
Veridata is trimming decimal part from the number, making the data as out of sync.
Value is correct when querying the database using SQLPLUS.


1) Create new Connection
2) Create new group
3) Create Compare Pair for Table. For e.g. <TABLE NAME>
4) Create new Job
5) Execute Job with Trace enabled

Same results were obtained where the decimal value is trimmed from the target side, and veridata is flagging this record as an out of sync record.




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.