My Oracle Support Banner

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

Last updated on SEPTEMBER 26, 2018

Applies to:

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

Symptoms


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

 

ERROR
-----------------------

 


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


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