Create Index CSF_PHONETIC_VALUES_U3 Fails As The Table Has Duplicate Keys

(Doc ID 987878.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Field Service - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Sep-2013***


Symptoms

When attempting to upgrade 12.1.1 the following error occurs:

The table is missing the index CSF_PHONETIC_VALUES_U3
or index CSF_PHONETIC_VALUES_U3 exists on another table.
Create it with the statement:


Start time for statement below is: Tue Jan 05 2010 16:11:05

CREATE UNIQUE INDEX CSF.CSF_PHONETIC_VALUES_U3 ON CSF.CSF_PHONETIC_VALUES
(LANGUAGE, PHONETIC, CODE) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4
) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_SEED

Statement executed.

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


Use the following SQL statement to identify the duplicate keys:

SELECT LANGUAGE, PHONETIC, CODE, count(*)
FROM CSF.CSF_PHONETIC_VALUES
GROUP BY LANGUAGE, PHONETIC, CODE
HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above




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