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 laterInformation 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
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 |