EDQ Deduplication Jobs Are Failing with Error "ORA-01653"

(Doc ID 2213993.1)

Last updated on DECEMBER 13, 2016

Applies to:

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


Business is having requirement to run DQ jobs in parallel. While running DQ jobs with below commands

start task for component DQMgr with BCName=Contact, BObjName=Contact, OpType=DeDuplication, DqSetting="'','Yes','dedupe'", objwhereclause="[Alias] = 'Batch1'"

Siebel task show status as completed, but no records are inserted in EDQ table SIEBEL_CONTACT__MATCHES . Also S_DEDUP_RESULT does not so all duplicate records, only few records are getting inserted in S_DEDUP_RESULT.


 [EDQ-07901] Work unit error: ORA-01653


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