Rollup patch 5708576 failure
Hi,
Apps 11.5.10.2
adwork001.log shows...
The table is missing the index AME_TEMP_TRANS_LOCKS_PK
or index AME_TEMP_TRANS_LOCKS_PK exists on another table.
Create it with the statement:
Start time for statement below is: Wed Mar 13 2013 02:19:00
CREATE UNIQUE INDEX HR.AME_TEMP_TRANS_LOCKS_PK ON HR.AME_TEMP_TRANS_LOCKS
(FND_APPLICATION_ID, TRANSACTION_TYPE_ID, TRANSACTION_ID) LOGGING PCTFREE
10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_INTERFACE
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 FND_APPLICATION_ID, TRANSACTION_TYPE_ID, TRANSACTION_ID, count(*)
Apps 11.5.10.2
adwork001.log shows...
The table is missing the index AME_TEMP_TRANS_LOCKS_PK
or index AME_TEMP_TRANS_LOCKS_PK exists on another table.
Create it with the statement:
Start time for statement below is: Wed Mar 13 2013 02:19:00
CREATE UNIQUE INDEX HR.AME_TEMP_TRANS_LOCKS_PK ON HR.AME_TEMP_TRANS_LOCKS
(FND_APPLICATION_ID, TRANSACTION_TYPE_ID, TRANSACTION_ID) LOGGING PCTFREE
10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_INTERFACE
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 FND_APPLICATION_ID, TRANSACTION_TYPE_ID, TRANSACTION_ID, count(*)
Tagged:
0