My Oracle Support Banner

Batch Deduplication Job Is Failing To Insert Records In S_dedup_result Table (Doc ID 2284734.1)

Last updated on MARCH 17, 2020

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.


Batch Deduplication Job is failing to insert records in s_dedup_result table

After executing Batch Deduplication Job in UCM,
siebel_account_candidates and siebel_account_matches staging tables are populated correctly in edq staging area which means edq is recieving the profiles for matching and its correctly generating match score and duplicates.

Issue is when inserting this back to OCH S_DEDUP_RESULT table. its failing with below error




The issue can be reproduced at will with the following steps:
1. Run DeDuplication batch job on DQ manager Component


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.