My Oracle Support Banner

812 Event Search Issue (Doc ID 2941721.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

There is an issue in event search when a case is linked to 2 alerts it break the search.
Below is the query in select clause causing the issue
[Error] Execution (66: 35): ORA-01427: single-row subquery returns more than one row

(SELECT kdd_case_links.parent_case_id
  FROM kdd_case_links
  WHERE kdd_case_links.link_id =
  TO_CHAR (E.n_event_skey)
  AND kdd_case_links.link_fl = 'Y'
  AND kdd_case_links.link_type_cd =
  'CASE_TO_ALERT'
  AND kdd_case_links.create_type_cd IN
  ('S', 'M'))

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
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.