Applying Patch Fails On Index FA_RX_LOV_U2 (Doc ID 2580459.1)

Last updated on MARCH 07, 2023

Applies to:

Goal

How to address errors in regards to index FA_RX_LOV_U1 and index FA_RX_LOV_U2 which fail with the following errors?
 

The index FA_RX_LOV_U2 on table FA_RX_LOV
has the wrong columns or the columns in the wrong order.

Index FA_RX_LOV_U2 currently in the database
is a unique index on the columns:
LOV_NAME
of the table FA_RX_LOV

Start time for statement below is:

CREATE UNIQUE INDEX FA."FA~RX~LOV~U2" ON FA.FA_RX_LOV (LOV_NAME,
ZD_EDITION_NAME) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE
10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS ONLINE TABLESPACE
APPS_TS_SEED

Statement executed.

AD Worker warning:
Warning: Column list already indexed
Ignoring the warning and continuing...

Refreshing Editioning View
AD Worker error:
Error while executing statement

AD Worker error:
ORA-20001: Cannot upgrade existing table from Patch Edition: FA_RX_LOV
ORA-06512: at "APPS.AD_ZD", line 26
ORA-06512: at "APPS.AD_ZD_SEED", line 65
ORA-06512: at "APPS.AD_ZD_SEED", line 1305
ORA-06512: at "APPS.AD_ZD_TABLE", line 1164
ORA-06512: at line 2

Solution

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