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

MOSC Banner

Upgrade patch 6678700 failing on gljen.odf

edited Aug 7, 2013 1:02PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
Hi,
Customer is upgrading from 11.5.10.2 to R12.1.1

R12 upgrade failing with the file gljen.odf

Problem Description
---------------------------------------------------
gljen.odf is failing with the below error.


CREATE UNIQUE INDEX GL.GL_JE_BATCHES_U2 ON GL.GL_JE_BATCHES (NAME,  DEFAULT_PERIOD_NAME, CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME,
ACCOUNTED_PERIOD_TYPE) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )  PCTFREE 0 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:

SELECT NAME, DEFAULT_PERIOD_NAME, CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME, ACCOUNTED_PERIOD_TYPE, count(*)
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