Upgrade patch 6678700 failing on gljen.odf
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(*)
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:
0