ORA-907 Error: MISSING RIGHT PARENTHESIS IN CMSSEARCH.EXECUTE EXCEPTION IN GRC Manager (Doc ID 760174.1)

Last updated on MARCH 29, 2016

Applies to:

Oracle Governance, Risk and Compliance Manager - Version 7.7.2 to 7.8 [Release Rel 12]
Information in this document applies to any platform.
***Checked for relevance on 28-Jan-2012***

Symptoms

When a GRC Manager user who is not an SOAGlobalICAdmin or SOAICAdmin logs in and clicks on the View All Processes link, the following Exception occurs:
.
Exception
ORA-907: missing right parenthesis in CMSSearch.Execute:
Search=SOA_BPCand('DOMAIN\user','admin','TEST Director's','D&T-Info-Operations','Research &
development','SEC-IDM-STL-R-sysmanager','collabuser','G_SOABPCreator','guest')
or
... ...
ntrolOwners>or*,guestor*,guest,*andRetiredxSOAIcPath,dDocTitleasc Type=SearchLatest.

This only happens to Active Directory Security Integration (ADSI) users who belong to an ADSI group which has an apostrophe in the name, like "TEST Director's", and that are not GRC Manager admins.

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