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 JULY 26, 2018
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 occured as consequence of, then the an entry is completed but not saved and then the entire event is being deleted
Description: Unexpected error occured 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!