User unable to perform Promote To Case action for some Alerts
(Doc ID 2774838.1)
Last updated on MAY 24, 2023
Applies to:
Oracle Financial Services Behavior Detection Platform - Version 8.0 and laterInformation 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 |