12.0.6 to 12.1.3 Upgade Fails With Missing Index AP_RECURRING_PAYMENTS_U2
Hi Support,
This error is from the 12.1.1 upgrade step:
*******************************************************
The table is missing the index AP_RECURRING_PAYMENTS_U2
or index AP_RECURRING_PAYMENTS_U2 exists on another table.
Create it with the statement:
Start time for statement below is: Fri Oct 25 2013 14:26:13
CREATE UNIQUE INDEX AP.AP_RECURRING_PAYMENTS_U2 ON
AP.AP_RECURRING_PAYMENTS_ALL (VENDOR_ID, RECURRING_PAY_NUM, ORG_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:
This error is from the 12.1.1 upgrade step:
*******************************************************
The table is missing the index AP_RECURRING_PAYMENTS_U2
or index AP_RECURRING_PAYMENTS_U2 exists on another table.
Create it with the statement:
Start time for statement below is: Fri Oct 25 2013 14:26:13
CREATE UNIQUE INDEX AP.AP_RECURRING_PAYMENTS_U2 ON
AP.AP_RECURRING_PAYMENTS_ALL (VENDOR_ID, RECURRING_PAY_NUM, ORG_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:
0