My Oracle Support Banner

User unable to perform Promote To Case action for some Alerts (Doc ID 2774838.1)

Last updated on MAY 13, 2021

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

User is unable to perform Promote to case action on some alerts on Production, below error in UmmService log.

UMMLOG] Apr 21,21 12:49:16 : [RDBMSDAOHANDLER]Execute query with prepared statement to get the Multi Select Options...SELECT cmmnt_id,cmmnt_tx FROM (Select kdd_cmmnt.cmmnt_id,kdd_cmmnt.cmmnt_tx, kdd_cmmnt_cat_cd.displ_order_nb,kdd_cmmnt.displ_order_nb From kdd_cmmnt inner join kdd_cmmnt_cat_cd on kdd_cmmnt.cmmnt_cat_cd =kdd_cmmnt_cat_cd.cmmnt_cat_cd,(select kr.scnro_class_cd from kdd_review kr where kr.review_id in (3695429,3682687)) alt_scrno WHERE kdd_cmmnt.cmmnt_id in (select kscc.cmmnt_id from kdd_scnro_class_cmmntkscc where kscc.scnro_class_cd = alt_scrno.scnro_class_cd) group by kdd_cmmnt.cmmnt_id,kdd_cmmnt.cmmnt_tx, kdd_cmmnt_cat_cd.displ_order_nb, kdd_cmmnt.displ_order_nb having count(1) = (SELECT count(1) AS count_alt FROM (SELECT ',' || '(3695429,3682687)' ||',' AS txt FROM dual) CONNECT BY level <= LENGTH(txt) - LENGTH(REPLACE(txt, ',', '')) - 1) order by kdd_cmmnt_cat_cd.displ_order_nb asc, kdd_cmmnt.displ_order_nb asc)

[UMMLOG] Apr 21,21 12:49:16 : [RDBMSDAOHANDLER]SQLException occured while calling Database Stored Procedure...

ORA-02291: integrity constraint (OFSAAFCCM.FK_693_2) violated - parent key not found

ORA-06512: at "OFSAAFCCM.PKG_PRMTCASE", line 2941

ORA-06512: at "OFSAAFCCM.PKG_PRMTCASE", line 5266

ORA-06512: at "OFSAAFCCM.PKG_PRMTCASE", line 2489

ORA-06512: at "OFSAAFCCM.PKG_PRMTCASE", line 1114

ORA-06512: at "OFSAAFCCM.PKG_AMUIACTIONWORKFLOW", line 4480

ORA-06512: at "OFSAAFCCM.PKG_AMUIACTIONWORKFLOW", line 9805

ORA-06512: at line 1

[UMMLOG] Apr 21,21 12:49:16 : [LOGGER]ORA-02291: integrity constraint (OFSAAFCCM.FK_693_2) violated - parent key not found

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


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