My Oracle Support Banner

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


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