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

Last updated on MAY 24, 2023

Applies to:

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

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