Physical Search Does Not Show Option List Items Correctly (Doc ID 1572960.1)

Last updated on MAY 10, 2016

Applies to:

Oracle WebCenter Content: Records - Version 10.1.3.5.0 and later
Information in this document applies to any platform.

Symptoms

Within URM, you perform a Physical Item search.  When this is done, there are two possible scenarios: 
   1.  When there are multiple pages of search results and I press [Next] the next page does not show any records 

   OR

   2. The search shows the following exception:
   Content Server Request Failed
   Unable to execute service GET_EXTERNAL_ITEM_SEARCH_RESULTS and function getExternalItemSearchResults.
   (System Error: Unable to create result set for query 'SELECT COUNT(*) FROM ExtItems,ExtItemsRM WHERE (ExtItems.dID = ExtItemsRM.dID) AND (UPPER(xDepartmentFaculty) LIKE UPPER('Deputy VC's Office') AND xDepartmentFaculty IS NOT NULL) AND ExtItems.dRmaProcessState <> 'D''. ORA-00907: missing right parenthesis)

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