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
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
ORA-06512: at "AERS.POPULATEQTEMP",
This issue was resolved in reported <
resurfaces after application of AERS iPatch 22.214.171.124.
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!