ORA-29861: Domain Index Is Marked LOADING/FAILED/UNUSABLE Index: ICX_CAT_ITEMSCTXDESC_HDRS (Doc ID 2215038.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Running supplier merge there is a failure due to this error:

icx.plsql.ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns Next Seq from icx_cat_items_ctx_requestid_s:297269
icx.plsql.ICX_CAT_UTIL_PVT.setWhoColumns Who columns; internal_request_id:297269, request_id:, user_id:12809, login_id:-1
icx.plsql.ICX_CAT_POPULATE_ITEM_PVT.populateVendorMerge l_to_vendor_name:SUPPLIER ABCD
icx.plsql.ICX_CAT_POPULATE_ITEM_PVT.populateVendorMerge --> l_err_loc:900 ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
po.plsql.PO_VendorMerge_GRP.Merge_VendorEND x_return_status = U

Checking the indexes for this table: SELECT * FROM all_indexes WHERE table_name = 'ICX_CAT_ITEMS_CTX_HDRS_TLP';
shows the problematic index:

INDEX_NAME: ICX_CAT_ITEMSCTXDESC_HDRS
INDEX_TYPE: DOMAIN
DOMIDX_STATUS: VALID
DOMIDX_OPSTATUS: FAILED

Need this index to be recreated or rebuilt and show valid.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms