The following error appeared on application side while trying to deploy the new SRF on the application, as you see from the above error it’s database error and to solve it follow the below steps :-
from database side :-
sqlplus /as sysdba
From the above picture check the index name and put it inside this query :-
select owner,index_name,table_name,status from dba_indexes where index_name=’index_name’;
OWNER INDEX_NAME TABLE_NAME STATUS
—– ———- ———- ——
owner index_name table_name INVALIDalter index ndex_name rebuild;
Try again
Cheers
Osama