SQLERRM=ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

EBS 12.1.3

RHEL 5.5 64 bit

DB 11.1.0.7

Hi All,

Two worker processes failed while doing 'maintain multilingual tables' using adadmin. The failed worker shows:

MESG

--------------------------------------------------------------------------------

LANGUAGE=AMERICAN

PACKAGE=IRC_IPT_SHD

SQLERRM=ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

select to_date('ERROR')

               *

ERROR at line 1:

ORA-01858: a non-numeric character was found where a numeric was expected

But I find not such issue in the database:

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

no rows selected

SQL>

SQL> select distinct status from user_indexes where index_type like '%DOMAIN%';