getting "index cannot be created as the table has duplicate keys" error with bomstrc.odf during 11i
hi,
We are currently running EBS 11iCU2 to R12 Upgrade (database version=11.2.0.3, application version=11.5.10.2, OS= Linux 2.6.32-358.el6.x86_64 )
this is a show stopper for us to proceed,
We have currently 5875 jobs remaining (current phase=A275) when running this bomstrc.odf, we are getting the following error
=========================================================================================
/Apps/oaperf/product/12.1/bom/12.0.0/patch/115/odf/bomstrc.odf
CREATE UNIQUE INDEX BOM.BOM_STRUCTURES_B_U1 ON BOM.BOM_STRUCTURES_B
(OBJ_NAME, PK1_VALUE, PK2_VALUE, ALTERNATE_BOM_DESIGNATOR) LOGGING STORAGE
(FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX
Statement executed.
AD Worker error: The index cannot be created as the table has duplicate keys.
We are currently running EBS 11iCU2 to R12 Upgrade (database version=11.2.0.3, application version=11.5.10.2, OS= Linux 2.6.32-358.el6.x86_64 )
this is a show stopper for us to proceed,
We have currently 5875 jobs remaining (current phase=A275) when running this bomstrc.odf, we are getting the following error
=========================================================================================
/Apps/oaperf/product/12.1/bom/12.0.0/patch/115/odf/bomstrc.odf
CREATE UNIQUE INDEX BOM.BOM_STRUCTURES_B_U1 ON BOM.BOM_STRUCTURES_B
(OBJ_NAME, PK1_VALUE, PK2_VALUE, ALTERNATE_BOM_DESIGNATOR) LOGGING STORAGE
(FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX
Statement executed.
AD Worker error: The index cannot be created as the table has duplicate keys.
Tagged:
0