Upgrade Patch Failed On Script msddem.odf - The Index Cannot Be Created As The Table Has Duplicate Keys
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.
On 12.1.1 version, when attempting to upgrade 22.214.171.124 to R12.1.3, the following error occurs during upgrade 12.1.1 driver:
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.
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