Query Module Event Duration Unit Conversion Functionality Not Working
Last updated on JULY 02, 2009
Applies to:Adverse Event Reporting System - Version: 22.214.171.124
This problem can occur on any platform.
In the AERS Query Module, the Unit Conversion logic does not appear to be working after applying AERS iPatch 126.96.36.199, the supplied unit entered by user is not taken into account by the underlying SQL query.
Steps To Reproduce:
The issue can be reproduced at will in AERS 188.8.131.52 environment using the following steps:
- Launch AERS 184.108.40.206
- Open the Query Module
- Navigate to the Events window
- In Event Duration enter <2
- In Event Duration Unit enter DAY
- Blank out the default deleted criteria (just to make the SQL simple)
- Open the SQL window
- Note the resulting SQL is per below:
((SELECT USERENV('SESSIONID') , AE_CASES.CASE_ID
FROM AE_EVENTS ,AE_CASES
WHERE AE_CASES.CASE_ID= AE_EVENTS.CASE_ID
AND QueryPkg.IsCriteriaMet(UPPER(AE_EVENTS.DURATION),'2',UPPER(AE_EVENTS.DURATION_UNIT),'','<','TIME','FEW',4)= 1
AND UPPER(AE_EVENTS.DURATION_UNIT) = 'DAY'
AND 0 = CHECKBLINDED(AE_CASES.CASE_ID, AE_CASES.PROD_CD,
The Call to QueryPkg.IsCriteriaMet is missing the unit and that there is an "extra" and clause for the unit AND UPPER(AE_EVENTS.DURATION_UNIT) = 'DAY'
Therefore execution of query does not retrieve correct results
AERS 220.127.116.11 has recently been applied
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