My Oracle Support Banner

ORA-907 Error: Missing Right Parenthesis in CMSSEARCH.EXECUTE EXCEPTION in GRC Manager (Doc ID 760174.1)

Last updated on JANUARY 04, 2021

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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.