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 126.96.36.199.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.
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.
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