Search (GET_SEARCH_RESULTS) Fails With ORA-00936 After Upgrading To WebCenter Content 11.1.1.7 MLR2, MLR3 or MLR4 (Doc ID 1676067.1)

Last updated on AUGUST 30, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

After upgrading WebCenter Content 11.1.1.7 to MLR2, MLR3 or MLR4, searches that return content items with multiple item values in a multiselect list field may fail and throw the following error:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms