TABLE IS MISSING THE INDEX CZ_ARCHIVE_REFS_PK WHEN UPGRADING TO 12.2 (Doc ID 2001960.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Configurator - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Patch Application Issues

While upgrading from 11i to R12.2 using Patch 10124646 - ORACLE E-BUSINESS SUITE RELEASE 12.2.0 [R12.2] UPGRADE DRIVER, an error is encountered when applying upgrade patch driver (u10124646.drv).

Support found the following potential solutions:

Note 1667782.1 - R121.1. upgrade: czpkctr2.sql and czrp.odf Jobs Fail when running upgrade driver
which pointed to:
Bug 14846811 - R12 UPGRADE PATCH DRIVER U6678700 ISSUES - DUPLICATE KEYS
which pointed to:
Bug 18499534 - TWO JOBS FAIL WHEN RUNNING THE 12.1.1 DRIVER / patch provided = 18499534:R12.CZ.B
My Customer is upgrading from 11i to 12.2, so I found the following:
Bug 19621864 has been created to port this bug to 12.2.
However this Bug is active and in status 11.



ERROR
-----------------------
The table is missing the index CZ_ARCHIVE_REFS_PK or index CZ_ARCHIVE_REFS_PK exists on another table.

CREATE UNIQUE INDEX CZ."CZ_ARCHIVE_REFS_PK" ON CZ.CZ_ARCHIVE_REFS
(DEVL_PROJECT_ID, SEQ_NBR) 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:
Applying upgrade patch driver (u10124646.drv).

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