Patch Application with ozfinter.odf File Error: "The index cannot be created as the table has duplicate keys." (Doc ID 1537630.1)

Last updated on NOVEMBER 05, 2015

Applies to:

Oracle Trade Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Channel Revenue Management (ChRM) Consolidated patch or any other patch which contains latest versions of ozfinter.odf file, creates a unique index OZF_XLA_CLAIM_HEADERS_U2 on CLAIM_ID and RELATED_EVENT_ID columns of OZF_XLA_CLAIM_HEADERS table.  Patch is failing to create index.

Error

AD Worker error:
The index cannot be created as the table has duplicate keys. 

Patch application fails if any duplicate records exists for this combination.



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