My Oracle Support Banner

Error while applying EMEA Add-on Localizations - Upgrade patch 18712060 (Doc ID 2541893.1)

Last updated on SEPTEMBER 09, 2019

Applies to:

EMEA Add-on Localizations - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

 Reported Issue
 -----------------
 When applying patches as per EMEA Add-on Localizations - Upgrade steps to 12.2 (Doc ID 1593750.1) , post R12.2.7 upgrade, found patches were failed during application.
 Customer was trying to upgrade from r12.1.3 to R12.2 


 Steps followed
 -----------------
 1. Run adsplice on fs1 . 
 2. Verify successful Splicing of EMEA Add-on Localizations on fs1 .
 3. Apply 12.2 CLE Codeline patch and Upgrade patch on fs1 .
 4. Apply patches 13768679 and 27638664 
 5. Patch 18712060 failed during application.

 

Error message 
----------------

Index FIFO_LAYER_PKEY exists under CLE schema.
Checking for differences
Column_name and Uniqueness do not match for both file and DB Indexes
Creating Revised index
Drop query is DROP INDEX CLE."FIFO~LAYER~PKEY"
Drop query is DROP INDEX CLE."FIFO~LAYER~PKEY"
Error in executing statement: CREATE UNIQUE INDEX "CLE"."FIFO~LAYER~PKEY" ON "CLE"."CLEF292_CST_FIFO_LAYERS" ("FIFO_LAYER_ID")
PCTFREE 10 INITRANS 11 MAXTRANS 255
STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
ONLINE
Error message is: ORA-00955: name is already used by an existing object


Expected Behavior 
--------------------
Patch 18712060 should be allowed for application successfully. 

Cause

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
Symptoms
Cause
Solution


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