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:
Oracle iProcurement - Version 12.1.3 and laterInformation 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: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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |