ICX_TRANSACTIONS.xdf Failed to Create Index ICX_TRANSACTIONS_U1 While Applying Patch 6435000 (Doc ID 1081195.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Applications DBA - Version 12.0.4 to 12.0.4 [Release 12]
Information in this document applies to any platform.
***Checked for relevance on 25-Jun-2013***

Symptoms

When attempting to apply the EBS 12.0.4 Release Update Pack <patch 6435000>
the following error occurs.

ERROR

Applying XDF file : /<APPL_TOP>/apps_st/appl/fnd/12.0.0/patch/115/xdf/icx_transactions.xdf

Table Name is ICX_TRANSACTIONS
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 17
The table definition in the XDF is the same as the one in DB.

Executing grants on ICX_TRANSACTIONS to APPS
GRANT ALL ON ICX.ICX_TRANSACTIONS TO APPS WITH GRANT OPTION
Synonyms match.

Index hashcode(s) extracted from the XDF.

Hashcodes generated for DB indexes.

Index ICX_TRANSACTIONS_N1 matches exactly with the XDF definition.
Index ICX_TRANSACTIONS_U2 matches exactly with the XDF definition.
Index ICX_TRANSACTIONS_U1 does not exist in ICX.

CREATE UNIQUE INDEX "ICX"."ICX_TRANSACTIONS_U1" ON "ICX"."ICX_TRANSACTIONS" ("TRANSACTION_ID")
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
PARALLEL NOLOGGING
ALTER INDEX ICX.ICX_TRANSACTIONS_U1 NOPARALLEL LOGGING
Start time for statement above is Sat Apr 03 19:53:07 GMT+08:00 2010
Start time for statement above is Sat Apr 03 19:53:52 GMT+08:00 2010
ORA-12801 error occured during Index creation.

Updating task with status 1

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