My Oracle Support Banner

ORA-00907, ORA-06512 When Using Case Query Functionality With Multiple Exclusions (Doc ID 762597.1)

Last updated on JULY 16, 2010

Applies to:

Adverse Event Reporting System - Version: 3.0 and later   [Release: 3 and later ]


When using the Case Query functionality and including more than one exclusion criteria, the
following error occurs:

ORA-00907: missing right parenthesis
ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "AERS.POPULATEQTEMP", line 469

This issue was resolved in reported <> and resolved in AERS iPatch, however
resurfaces after application of AERS iPatch

Steps To Reproduce
The issue can be reproduced at will with the following steps:
1. Log into AERS 4.6
2. Select Case Query
3. Events--> Preferred Term add multiple exclusions under a single component.
4. Press F8 to execute query and error will be returned


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

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