Bug In Reporterstate Validation SQL
(Doc ID 2505561.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.1.2 to 8.2 [Release 8.1 to 8.2]Microsoft Windows x64 (64-bit)
Symptoms
The validation sql for OOB EMA R2 profile for the element <reporterstate> fails for the valid states everytime.
SELECT CASE
WHEN COUNT (1) > 0
THEN 1
ELSE 0
END failure
FROM case_reporters
WHERE case_id = 1348877
AND primary_contact = 1
AND state NOT IN
('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11','12', '13', '14', '15', '16', '17', '18', '19')
AND country_id = 195;
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 |