Error 305100085: User Unable to Accept R3 Initial ICSR from ICSR Pending Screen in Argus Safety
(Doc ID 3021534.1)
Last updated on AUGUST 06, 2024
Applies to:
Oracle Life Sciences Argus Interchange - Version 8.1.3 and laterOracle Life Sciences Argus Interchange Cloud Service - Version 8.2 and later
Information in this document applies to any platform.
Symptoms
While accepting the incoming R3 ICSR Reports via Reports -> ICSR Pending screen, user encountered following error :
Error No 305100085: Unexpected Error Occurred. Error in accepting the case. Please contact System Administrator.
Following detailed error was logged under Utilities -> Logs -> View Error Log screen :
ORA-00001: unique constraint (ARGUS_APP.AK_CSM_CASE_NUM) violated-ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 88
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 1512
^@^Populate_Case_Table(CASE_MASTER)^@^INSERT INTO CASE_MASTER(RPT_TYPE_ID,INIT_REPT_DATE,SAFETY_DATE,INIT_REPT_DATE_J,COUNTRY_ID, CASE_ID, LAST_UPDATE_USER_ID, CREATE_TIME, LAST_UPDATE_TIME, USER_ID, CASE_NUM, SITE_ID, REV, STATE_ID, SID) VALUES (:RPT_TYPE_ID,to_date(:INIT_REPT_DATE, 'DD-MON-YYYY HH24:MI:SS'),to_date(:SAFETY_DATE, 'DD-MON-YYYY HH24:MI:SS'),to_date(:INIT_REPT_DATE_J, 'DD-MON-YYYY HH24:MI:SS'),:COUNTRY_ID,:CASE_ID,:LAST_UPDATE_USER_ID,:CREATE_TIME,:LAST_UPDATE_TIME,:USER_ID,:CASE_NUM,:SITE_ID,:REV,:STATE_ID,:SID). Stored Procedure: Populate_Case_Table(CASE_MASTER)
ORA-00001: unique constraint (ARGUS_APP.AK_CSM_CASE_NUM) violated-ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 88
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 1512
^@^Populate_Case_Table(CASE_MASTER)^@^INSERT INTO CASE_MASTER(RPT_TYPE_ID,INIT_REPT_DATE,SAFETY_DATE,COUNTRY_ID, CASE_ID, LAST_UPDATE_USER_ID, CREATE_TIME, LAST_UPDATE_TIME, USER_ID, CASE_NUM, SITE_ID, REV, STATE_ID, SID) VALUES (:RPT_TYPE_ID,to_date(:INIT_REPT_DATE, 'DD-MON-YYYY HH24:MI:SS'),to_date(:SAFETY_DATE, 'DD-MON-YYYY HH24:MI:SS'),:COUNTRY_ID,:CASE_ID,:LAST_UPDATE_USER_ID,:CREATE_TIME,:LAST_UPDATE_TIME,:USER_ID,:CASE_NUM,:SITE_ID,:REV,:STATE_ID,:SID). Stored Procedure: Populate_Case_Table(CASE_MASTER)
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 1512
^@^Populate_Case_Table(CASE_MASTER)^@^INSERT INTO CASE_MASTER(RPT_TYPE_ID,INIT_REPT_DATE,SAFETY_DATE,INIT_REPT_DATE_J,COUNTRY_ID, CASE_ID, LAST_UPDATE_USER_ID, CREATE_TIME, LAST_UPDATE_TIME, USER_ID, CASE_NUM, SITE_ID, REV, STATE_ID, SID) VALUES (:RPT_TYPE_ID,to_date(:INIT_REPT_DATE, 'DD-MON-YYYY HH24:MI:SS'),to_date(:SAFETY_DATE, 'DD-MON-YYYY HH24:MI:SS'),to_date(:INIT_REPT_DATE_J, 'DD-MON-YYYY HH24:MI:SS'),:COUNTRY_ID,:CASE_ID,:LAST_UPDATE_USER_ID,:CREATE_TIME,:LAST_UPDATE_TIME,:USER_ID,:CASE_NUM,:SITE_ID,:REV,:STATE_ID,:SID). Stored Procedure: Populate_Case_Table(CASE_MASTER)
ORA-00001: unique constraint (ARGUS_APP.AK_CSM_CASE_NUM) violated-ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 88
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 1512
^@^Populate_Case_Table(CASE_MASTER)^@^INSERT INTO CASE_MASTER(RPT_TYPE_ID,INIT_REPT_DATE,SAFETY_DATE,COUNTRY_ID, CASE_ID, LAST_UPDATE_USER_ID, CREATE_TIME, LAST_UPDATE_TIME, USER_ID, CASE_NUM, SITE_ID, REV, STATE_ID, SID) VALUES (:RPT_TYPE_ID,to_date(:INIT_REPT_DATE, 'DD-MON-YYYY HH24:MI:SS'),to_date(:SAFETY_DATE, 'DD-MON-YYYY HH24:MI:SS'),:COUNTRY_ID,:CASE_ID,:LAST_UPDATE_USER_ID,:CREATE_TIME,:LAST_UPDATE_TIME,:USER_ID,:CASE_NUM,:SITE_ID,:REV,:STATE_ID,:SID). Stored Procedure: Populate_Case_Table(CASE_MASTER)
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |