This content has been marked as final. Show 4 replies
The Error comes when An attempt was made to access a function-based index that has been marked disabled because the function on which the index depends has been changed.
You can check the index status from below queries
select owner, index_name, status, domidx_status, domidx_opstatus,funcidx_status from dba_indexes where domidx_opstatus is not null;
Rebuilding the index is solution for this
You can refer to note id 958746.1 and 560202.1 for more details.