My Oracle Support Banner

Applying Patch Fails On Index FA_RX_LOV_U2 (Doc ID 2580459.1)

Last updated on NOVEMBER 25, 2020

Applies to:

Oracle Assets - Version 12.2.5 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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