Bug In Reporterstate Validation SQL (Doc ID 2505561.1)

Last updated on JULY 13, 2023

Applies to:

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

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