My Oracle Support Banner

Error 305100085: Error Occurred While Accepting the Case (Doc ID 2833355.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Interchange - Version 8.2.1 and later
Oracle Life Sciences Argus Interchange Cloud Service - Version 8.2 and later
Microsoft Windows x64 (64-bit)

Symptoms

User encountered following error while accepting the R3 file under Reports -> ICSR Pending screen :

"Error No. 305100085: Un-expected error occurred. Error in accepting the case. Please contact System Administrator."

 

Steps to repeat:

1. Login to Argus Safety

2. Go to Reports -> ICSR Pending

3. Select the report -> Right Click -> Select Duplicate Search

4. Perform the search in "Duplicate Search Window".

5. Accept the ICSR report as Initial or Follow-up.

6. Provide the user credentials. Following error encountered -

 

  

 

Below detailed error was observed in Utilities -> Logs -> View Error Log screen for above issue -

  

"ORA-00957: duplicate column name
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 73
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 82
Bind Variables::SEQ_NUM = XXXXXXXCASE_ID = XXXXXXMISUSE = XOBTAIN_DRUG_COUNTRY_ID = XXOFF_LABEL_USE = XSORT_ID = X
SQL:UPDATE CASE_PROD_DRUGS SET OBTAIN_DRUG_COUNTRY_ID = :OBTAIN_DRUG_COUNTRY_ID,OFF_LABEL_USE = :OFF_LABEL_USE,MISUSE = :MISUSE,OFF_LABEL_USE = :OFF_LABEL_USE WHERE CASE_ID = :CASE_ID AND SEQ_NUM = :SEQ_NUM
PL/SQL Call Stack:
SQL
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
18 PKG_UTL_SQL.P_LOG_SQL_ERROR
87 PKG_UTL_SQL.F_EXECUTE_SQL
3102 ICSR_CASE_CREATE_R3.POPULATE_REPEATER_DATA
2038 ICSR_CASE_CREATE_R3.POPULATE_CASE_PRODUCT
630 ICSR_CASE_CREATE_R3.MAIN_CREATE_CASE_R31 __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

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