Event Occured As Consequence Error On Case Save - ORA-02291: integrity constraint (ARGUS_APP.FK_CASE_EVENT_DETAIL_SEQ_NUM) violated - parent key not found
(Doc ID 2426583.1)
Last updated on MAY 11, 2021
Applies to:Oracle Argus Safety - Version 7.0.5 and later
Information in this document applies to any platform.
On Applications Oracle Argus Safety Version : 7.0.5
If an event with an entry in event occurred as a consequence of it being deleted without having saved the event/consequence combination once. It is not possible to save the case.
Description: Please contact your system administrator
On checking [Utilities] - Logs - Error Log below entry is created:
SQL execution error, ORA-02291: integrity constraint (ARGUS_APP.FK_CASE_EVENT_DETAIL_SEQ_NUM) violated - parent key not found
ORA-06512: at "ARGUS_APP.GSS_CASE", line 4783
ORA-06512: at line 1
SQL: BEGIN GSS_CASE.P_CASE_EVENT_CONSEQUENCE_IU(:PI_CASE_ID, :PI_SEQ_NUM, :PI_ED_SEQ_NUM, :PI_EVT_CONSEQUENCE_ID, :PI_CONSEQUENCE, :PI_TERM, :PI_CONSEQUENCE_J, :PI_TERM_J);
Another error is displayed when the event was saved without an entry in the 'event occurred as consequence of' field, then an entry is completed but not saved and then the entire event is deleted
Description: Unexpected error occurred during execution of Delete Case_event_details ! -- 2292 :ORA-02292: integrity constraint (ARGUS_APP.FP_CASE_EVENT_DETAIL_SEQ_NUM) violated - child record found Please inform your administrator!
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