Patch 13965896:R12.INV.B fails on creating in dex : CREATE INDEX INV.MTL_MATERIAL_TRANSACTIONS_N1
Hi,
Patch 13965896:R12.INV.B fails on creating in dex : CREATE INDEX INV.MTL_MATERIAL_TRANSACTIONS_N1
The log file is showing :
CREATE INDEX INV.MTL_MATERIAL_TRANSACTIONS_N1 ON
INV.MTL_MATERIAL_TRANSACTIONS (INVENTORY_ITEM_ID, ORGANIZATION_ID,
TRANSACTION_DATE) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE
10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS PARALLEL TABLESPACE
APPS_TS_TX_IDX
Statement executed.
The CREATE INDEX statement above failed because there is
another index on the same columns.
A select on the index is giving :
Select index_owner,index_name,column_name from all_ind_columns
where column_name in ('INVENTORY_ITEM_ID', 'ORGANIZATION_ID','TRANSACTION_DATE')