Physical Search Does Not Show Option List Items Correctly
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.
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
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms