User cannot save a case, getting Error No: 305100073 : Error Executing Gss_util.F_update_worklist_for_case

(Doc ID 1095253.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Argus Safety - Version 4.2.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 10-MAY-2012***
***Checked for relevance on 19-Aug-2014***

Symptoms

Customer is getting the following error trying to save a case:

 

Oracle error 8197 occurred.SQL execution error, ORA-20006: ORA-01403: no data foundORA-06512: at "ARGUS_APP.GSS_UTIL", line 963ORA-06512: at line 1SQL: begin :P_RESULT := gss_util.f_update_worklist_for_case(:P_CASE_ID); end;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms