My Oracle Support Banner

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

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Interchange - Version 7.0.0.1 and later
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution


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