Advanced Pricing (QP) Index Failing On Upgrade To R12 or While Applying a Patch (Doc ID 552927.1)

Last updated on AUGUST 02, 2022

Applies to:

Symptoms

Problem Statement:
When attempting to do an R12 upgrade (4440000), patching suspended due to unique index failure, at
Step 10 the following error occurs:

ERROR
QP INDEX FAILING ON UPGRADE FROM 11.5.10 TO 12
The table is missing the index QP_SEGMENTS_B_U2 or index QP_SEGMENTS_B_U2 exists on another table.
The index cannot be created as the table has duplicate keys.

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
Run the American English upgrade patch driver (required)
Run the driver on the administration server node on your Release 12 APPL_TOP using the following
commands:
$ adpatch options=nocopyportion,nogenerateportion


13 Run AutoPatch R120 qptab.odf FAILED


CREATE UNIQUE INDEX QP.QP_SEGMENTS_B_U2 ON QP.QP_SEGMENTS_B (SEGMENT_CODE,
PRC_CONTEXT_ID) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE
10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX

Statement executed.

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

Other symptoms that could be present

Script qptab.odf fails : CREATE UNIQUE INDEX QP."QP_SEGMENTS_B  with Error : The index cannot be created as the table has duplicate keys

The table is missing the index QP_SEGMENTS_B_U2 or index QP_SEGMENTS_B_U2 exists on another table.

Create it with the statement:

CREATE UNIQUE INDEX QP."QP_SEGMENTS_B_U2" ON QP.QP_SEGMENTS_B
(SEGMENT_CODE, PRC_CONTEXT_ID) LOGGING STORAGE (FREELIST GROUPS 4
FREELISTS 4 )  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE APPS_TS_TX_IDX

Statement executed.

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.