My Oracle Support Banner

(92618) Error Received when Generating Letters and Narratives in Argus (Doc ID 3023565.1)

Last updated on MAY 22, 2024

Applies to:

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


Symptoms

Users are reporting receiving the following errors when performing actions such as


Some Users are also reporting errors doing Case Action>Open and Utilities>Logs>View Error Log


Within the Argusvr2.log the following error is being written
Exception DetailsMessage
Error:1; Oracle error 1 occurred.
ORA-20001: Unable to add SQL and SQL bind xml into USER_CACHE database table.
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 209
ORA-06512: at line 1
SQL: BEGIN pkg_utl_sql.P_GET_RESULTS_FOR_VIEW(:PI_SQL, :PI_XMLTYPE_BIND, :PI_FIRST_ROW, :PI_LAST_ROW, :PI_USER_ID, :PI_USER_NAME, :PO_CACHE_ID, :PO_RESULT); END;
Stack Trace

And within the CMN_ERROR_LOG is written

Argus Safety.COM :- Oracle error 1 occurred.
ORA-20001: Unable to add SQL and SQL bind xml into USER_CACHE database table.
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 209
ORA-06512: at line 1
SQL: BEGIN pkg_utl_sql.P_GET_RESULTS_FOR_VIEW(:PI_SQL, :PI_XMLTYPE_BIND, :PI_FIRST_ROW, :PI_LAST_ROW, :PI_USER_ID, :PI_USER_NAME, :PO_CACHE_ID, :PO_RESULT); END;
PL/SQL Call Stack:
15300543207388985138
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
1 __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
References

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