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


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