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

Last updated on NOVEMBER 10, 2024

Applies to:

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:12345, 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.