Error ORA-01452 Cannot Create Unique Index While Applying Patch 3653484 (Doc ID 1277618.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle Assets - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

When applying Patch FIN_PF.G <Patch 3653484>, the adworker log file shows errors:

ERROR
-----------------------
CREATE UNIQUE INDEX FA.FA_MC_ADJUSTMENTS_U1 ON FA.FA_MC_ADJUSTMENTS
(SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID, ADJUSTMENT_LINE_ID) LOGGING
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS PARALLEL TABLESPACE
APPS_TS_TX_IDX

AD Worker error:
The following ORACLE error:

ORA-12801: error signaled in parallel query server P002
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

occurred while executing the SQL statement:

CREATE UNIQUE INDEX FA.FA_MC_ADJUSTMENTS_U1 ON FA.FA_MC_ADJUSTMENTS
(SET_OF_BOOKS_ID, TRANSACTION_HEADER_ID, ADJUSTMENT_LINE_ID) LOGGING
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS PARALLEL TABLESPACE
APPS_TS_TX_IDX

Changes

<Patch 3653484>

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