Our database is running 220.127.116.11 and suddenly we got the issue.
the error occurred during refresh of materialized view, its been running for a while and suddenly its having issue during refresh.
here is the error on the alert log.
Errors in file /opt/app/oracle/diag/rdbms/cxxxa/CXXXA/trace/CXXXA_ora_1686.trc (incident=1985798): ORA-00600: internal error code, arguments: [kkqvmRmViewFromLst1], , , , , , , , , , ,  Incident details in: /opt/app/oracle/diag/rdbms/cxxxa/CXXXA/incident/incdir_1985798/CXXXA_ora_1686_i1985798.trc Sat Oct 11 14:12:41 2014
as per oracle its a known bug on 18.104.22.168 and not patch available for 22.214.171.124 they just given a work around.
1. create a view on the select statement on materialized view 2. create/refresh the materialized view and using the view created earlier.
for now it is working for us. here’s a note from oracle support:
Based on the symptoms and call stack trace, your issue seems similar to Bug 17345064 : XF126.96.36.199APPLY - TRC - KKQVMRMVIEWFROMLST, which is in status 11, still being worked by Oracle Development team.
thanks for visiting..