My Oracle Support Banner

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

Last updated on JULY 30, 2018

Applies to:

Oracle GoldenGate Veridata - Version 12.2.1.2.0 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.

Symptoms

1) Create new Connection
2) Create new group
3) Create Compare Pair for Table. For e.g. XXRCI_AR_DEALER_COGS_SBLDG_HDR
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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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