Error while applying IN60107 Patch - System failed patch application
the patch log.
Retrying the CREATE INDEX statement...
CREATE UNIQUE INDEX JA.JAI_TEMPL_ITM_REGNS_U2 ON JA.JAI_TEMPL_ITM_REGNS (TEMPL_ORG_REGNS_ID, INVENTORY_ITEM_ID) LOGGING PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX
Statement executed.
ODF Comparison Utility error:
The index cannot be created as the table has duplicate keys.
Use the following SQL statement to identify the duplicate keys:
SELECT TEMPL_ORG_REGNS_ID, INVENTORY_ITEM_ID, count(*)
FROM JA.JAI_TEMPL_ITM_REGNS
GROUP BY TEMPL_ORG_REGNS_ID, INVENTORY_ITEM_ID
HAVING count(*)>1
ODF Comparison Utility error:
Unable to compare or correct tables or indexes or keys
Retrying the CREATE INDEX statement...
CREATE UNIQUE INDEX JA.JAI_TEMPL_ITM_REGNS_U2 ON JA.JAI_TEMPL_ITM_REGNS (TEMPL_ORG_REGNS_ID, INVENTORY_ITEM_ID) LOGGING PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX
Statement executed.
ODF Comparison Utility error:
The index cannot be created as the table has duplicate keys.
Use the following SQL statement to identify the duplicate keys:
SELECT TEMPL_ORG_REGNS_ID, INVENTORY_ITEM_ID, count(*)
FROM JA.JAI_TEMPL_ITM_REGNS
GROUP BY TEMPL_ORG_REGNS_ID, INVENTORY_ITEM_ID
HAVING count(*)>1
ODF Comparison Utility error:
Unable to compare or correct tables or indexes or keys
Tagged:
0