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.


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.


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.


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