Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

getting "index cannot be created as the table has duplicate keys" error with bomstrc.odf during 11i

edited Aug 20, 2021 10:03AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
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.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center