My problem is similar to this one:
Except that it happens when I try to created an Activity in the Project Navigator. If I try the steps described in the link above, it is still not working. I also tried these steps below - very similar - without success:
I ran that query in Oracle SQL Developer to find the incorrect indexes and I have 3.
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');
Following the two procedures above on all three incorrect indexes solved nothing.
In the Search Domain page of an incorrect index, trying to drop that index displays that error:
internal error code, arguments: [12806], [kkdcdtc: missing object], [], [], [], [], [], [], [], [], [], []
Failed executing statement (ORA-00600: internal error code, arguments: [12806], [kkdcdtc: missing object], [], [], [], [], [], [], [], [], [], [])
After that, I am able to complete the steps in the procedures above but the result is still the same at the end and if I try to add an Activity under a SubProject in the Project Navigator, I still have this error:
domain index is marked LOADING/FAILED/UNUSABLE
Details are:
Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at line 16
ORA-06512: at "IFSAPP.ACTIVITY_API", line 10164
ORA-06512: at "IFSAPP.ACTIVITY_API", line 10227
ORA-06512: at "IFSAPP.ACTIVITY_API", line 10281
ORA-06512: at "IFSAPP.ACTIVITY_API", line 2408
ORA-06512: at "IFSAPP.ACTIVITY_API", line 2415
ORA-06512: at line 10
at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
--- End of inner exception stack trace ---
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)
