When uploading files in Ancillary Data I get the error "ORA-29861: domain index is marked loading/failed/unusable".

When uploading files in Ancillary Data I get the error "ORA-29861: domain index is marked loading/failed/unusable".

Please try the following steps:

1- Connect to SQL plus using the schema user/password

2- Run this query: select index_name,index_type,status,domidx_status,domidx_opstatus from user_indexes where index_type like '%DOMAIN%' and (domidx_status <> 'VALID' or domidx_opstatus <> 'VALID');

3- There will be an index with a FAILED state, run this query to fix it:  alter index FAILED_DOMAIN_INDEX_NAME rebuild;