Unable To Transmit Report From Bulk Report Screen - ORA-00001: unique constraint (ESM_OWNER.PK_ESM_RPT_DETAIL)
(Doc ID 2882990.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Interchange - Version 8.2.2 and laterInformation in this document applies to any platform.
Goal
Attempting to transmit the reports for any agencies from the Bulk report screen, getting following error message:
Error No: 305100084 Description: Failed to transmit report/s. Please check cmn_error_log for detail error.
Below error message is getting captured in CMN_ERROR_LOG:
Oracle error 1 occurred.
ORA-20005: ORA-01400: cannot insert NULL into ("ARGUS_APP"."RPT_EXP_INCL_EVENT"."LICENSE_ID")
ORA-06512: at "ARGUS_APP.GSS_UTIL", line 3773
ORA-06512: at line 1
SQL: BEGIN gss_util.p_mark_as_generated(:P_REG_RPT_ID,:P_RETURN_CODE); END;
Oracle error 1 occurred.
ORA-20005: ORA-01400: cannot insert NULL into ("ARGUS_APP"."RPT_EXP_INCL_EVENT"."LICENSE_ID")
ORA-06512: at "ARGUS_APP.GSS_UTIL", line 3773
ORA-06512: at line 1
SQL: BEGIN gss_util.p_mark_as_generated(:P_REG_RPT_ID,:P_RETURN_CODE); END;
Additionally the warning below is noted when SQL*Times is enabled (Per Note 1087179.1: Enabling Debug (SQLTIMES) - Oracle Argus Safety)
ORA-00001: unique constraint (ESM_OWNER.PK_ESM_RPT_DETAIL)
Solution
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
| Goal |
| Solution |
| References |