My Oracle Support Banner

Error During ICH PSUR Final Report Generation - ORA-20004: ORA-06512: at "ARGUS_APP.GSS_PERIODIC", line 14036 (Doc ID 2418606.1)

Last updated on JULY 13, 2023

Applies to:

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

Symptoms

On Applications Oracle Life Sciences Argus Safety Version : 8.1.1

Generated the ICH PSUR

Not hitting any issues while generating draft version of the report (multiple drafts ran fine)

However, when attempt to generate the final version the report fails with below error:

Argus Safety.COM :-
Oracle error 1 occurred.
ORA-20004: ORA-06512:
at "ARGUS_APP.GSS_PERIODIC", line 14036
ORA-06512: at "ARGUS_APP.GSS_PERIODIC", line 13459
ORA-06512: at "ARGUS_APP.GSS_PERIODIC", line 13490
ORA-06512: at line 1
SQL: BEGIN  GSS_PERIODIC.P_PER_RPT_GEN_END(:P_AS_BG_RPT_QUEUE_ID,  :P_AS_BG_REG_RPT_ID, :P_AS_BG_RPT_FORM_ID, :P_AS_BG_QUEUE_STATUS, :P_AS_BG_ENTERPRISE_ID,  :P_AS_BG_USER_ID, :P_AS_BG_DRAFT_FINAL, :P_AS_BG_TO_ADDRESS,  :P_AS_BG_AG_SRV_UID, :P_AS_BG_MAIL_SUBJ, :P_AS_BG_MAIL_BODY, :P_AS_BG_RPT_STATUS_ID, :P_SCHEDULED_ON_BIP);  END;PL/SQL Call Stack:  SQL673        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
References


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