Batch Deduplication Job Is Failing To Insert Records In S_dedup_result Table

(Doc ID 2284734.1)

Last updated on JANUARY 29, 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms