search did not return expected rows in GUI, stdlog report ORA: 3113:ORA-03113

Document ID : KB000045618
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:
Using "Additional Search Arguments" field to add some where clause, the syntax of the query is correct but we see this error in stdlog
<<
Fetch error dbfetchDLNX. ORA: 3113:ORA-03113: end-of-file on communication channel Process ID: 4681 ... + sql_clause = SELECT......
>>

Answer:
Title of the defect reported with Oracle Support is:
"Bug 9336802  Dump on evaopn2/3 with nls_comp=linguistic & nls_sort=binary_ci set" 
This problem is with Oracle database, it is solved in version higher 11.2.0.2.0.