Performing Physical Search in WebCenter Content (WCC): Records (RM) Generates Error: "Unable to execute service GET_EXTERNAL_ITEM_SEARCH_RESULTS..." (Doc ID 2057344.1)

Last updated on DECEMBER 22, 2016

Applies to:

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

Symptoms

An attempt to execute a Physical Search in URM generates the following error:

ERROR
-----------------------
Content Server Request Failed
Error Unable to execute service GET_EXTERNAL_ITEM_SEARCH_RESULTS and function getExternalItemSearchResults.
The error was caused by an internally generated issue. The error has been logged. 

STEPS
-----------------------
The issue can be reproduced with the following steps:
When performing a Physical Search
1. Search > Physical >
2. Object Type starts with "Box" and
3. Media Type starts with "Box"
4. Error is thrown

ERROR SEEN IN TRACING
--------------------------------
ORA-00904: "XCLBRAROLELIST": invalid identifier

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