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

MOSC Banner

Patch 6678700 fails on frmxml.odf

edited May 23, 2013 12:25PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓

Hi Everybody
Applying patch 6678700 fails on frmxml.odf with:
The table is missing the index FRM_USER_PUB_OPTIONS_UK1
or index FRM_USER_PUB_OPTIONS_UK1 exists on another table.
Create it with the statement:


Start time for statement below is: Fri May 17 2013 17:59:33

CREATE UNIQUE INDEX FRM.FRM_USER_PUB_OPTIONS_UK1 ON
 FRM.FRM_USER_PUB_OPTIONS (REPORT_ID, USER_ID) 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.


Use the following SQL statement to identify the 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