Getting "Oracle Error 8197 Occurred.Sql Execution Error" When Accepting An E2b Report (Doc ID 1435158.1)

Last updated on AUGUST 21, 2014

Applies to:

Oracle Argus Interchange - Version 7.0.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Aug-2014***

Symptoms

Getting the following error when trying to accept an E2B file from E2B pending screen:

Argus Safety.COM :- Oracle error 8197 occurred.SQL execution error, ORA-20006: Update SUSAR flag: ORA-00900: invalid SQL statementORA-06512: at "ARGUS_APP.GSS_UTIL", line 1423ORA-06512: at line 1SQL: begin :P_RESULT := gss_util.f_update_for_case_save(: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