Upgrade Patch Failed On Script msddem.odf - The Index Cannot Be Created As The Table Has Duplicate Keys (Doc ID 1666146.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

Oracle Applications DBA - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.1 version, when attempting to upgrade 11.5.10.2 to R12.1.3, the following error occurs during upgrade 12.1.1 driver:

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

Warning: Object "MSD_DEM_ENTITY_QUERIES" is not registered in table "FND_OBJECT_TABLESPACES".
AD Worker error: The index cannot be created as the table has duplicate keys.

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