Receiving Error When Applying Federal Patch. Error in Executing Statement: CREATE UNIQUE INDEX "FV"."FV~FACTS~PRC~HDR~U2" ON "FV"."FV_FACTS_PRC_HDR" ("SET_OF_BOOKS_ID", "TREASURY_SYMBOL_ID", "FUND_VALUE#1", "CODE_TYPE") (Doc ID 2262929.1)

Last updated on MAY 09, 2017

Applies to:

Oracle U.S. Federal Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

Receiving error when applying patch Patch#24422526

Creating Revised index
Drop query is DROP INDEX FV."FV~FACTS~PRC~HDR~U2"
Drop query is DROP INDEX FV."FV~FACTS~PRC~HDR~U2"
Error in executing statement: CREATE UNIQUE INDEX "FV"."FV~FACTS~PRC~HDR~U2" ON "FV"."FV_FACTS_PRC_HDR" ("SET_OF_BOOKS_ID", "TREASURY_SYMBOL_ID", "FUND_VALUE#1", "CODE_TYPE")
  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 4096 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-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


CREATE UNIQUE INDEX "FV"."FV~FACTS~PRC~HDR~U2" ON "FV"."FV_FACTS_PRC_HDR" ("SET_OF_BOOKS_ID", "TREASURY_SYMBOL_ID", "FUND_VALUE#1", "CODE_TYPE")
  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
  TABLESPACE "APPS_TS_TX_IDX"
 ONLINE

 
ERROR
-----------------------
Error message is: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found



Changes

 

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