Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 13965896:R12.INV.B fails on creating in dex : CREATE INDEX INV.MTL_MATERIAL_TRANSACTIONS_N1

edited Sep 18, 2012 1:00AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

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')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center