My Oracle Support Banner

ORA-20004: EXCEPTION WHILE CALLING When Creating New Case (Doc ID 2951067.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.2.1 and later
Oracle Life Sciences Argus Safety Cloud Service - Version 8.2.1 and later
Information in this document applies to any platform.

Symptoms

Get the foll0wing error when trying to create a new case.

Argus Safety.COM :- Oracle error 1 occurred.
ORA-20004: EXCEPTION WHILE CALLING (Custom Function):
NAMED_CUSTOM.SF_CASE_LISTEDNESS FUNCTION - ORA-06550: line 1, column 20:PLS-00201:
identifier 'NAMED_CUSTOM.SF_CASE_LISTEDNESS' must be declared
ORA-06512: at "ARGUS_APP.GSS_UTIL", line 6809ORA-06512: at line 1
SQL: BEGIN :P_RESULT := GSS_UTIL.FN_SF_FUNCTION_EXEC(:PI_CUSTOM_FUNC_NAME, :P_CASE_ID, :PO_NUMBER, :PO_STRING, :PO_STRING_J); END;PL/SQL
Call Stack: 15300543207388985138673 PKG_CONSOLE_COMMON.P_ERROR_LOG1 __anonymous_block

  

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.