AD WORKER FAILED "THE INDEX CANNOT BE CREATED AS THE TABLE HAS DUPLICATE KEYS" GMD_FORMULA_SECURITY (Doc ID 2258711.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Process Manufacturing Product Development - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Patch Application Issues

When attempting to upgrade from 12.1.3 to 12.2.0,
the following error occurs.

ERROR
*** Reading objects from GMD schema

Reading table GMD_FORMULA_SECURITY from GMD schema ...
Reading table GMD_SECURITY_PROFILES from GMD schema ...
Reading table GMD_SECURITY_CONTROL from GMD schema ...
Reading table GMD_VPD_SECURITY from GMD schema ...

===== Table GMD_FORMULA_SECURITY all columns match.
===== Index GMD_FORMULA_SECURITY_I1 all columns match.
===== Index GMD_FORMULA_SECURITY_N1 all columns match.
===== Index GMD_FORMULA_SECURITY_N2 all columns match.
===== Index GMD_FORMULA_SECURITY_PK all columns match.
*******************************************************
The table is missing the index GMD_FORMULA_SECURITY_U1
or index GMD_FORMULA_SECURITY_U1 exists on another table.
Create it with the statement:

...

CREATE UNIQUE INDEX GMD."GMD_FORMULA_SECURITY_U1" ON
GMD.GMD_FORMULA_SECURITY (ORGN_CODE, USER_ID, RESPONSIBILITY_ID,
FORMULA_ID, OTHER_ORGN) 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.


STEPS
The issue can be reproduced at will with the following steps:
1. upgrade from 12.1.3 to 12.2.0
2. saw the error in adwork log.

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