My Oracle Support Banner

Error No 305100085: Un-expected Error Occurred While Accepting the E2B R3 Report (Doc ID 2850291.1)

Last updated on FEBRUARY 24, 2022

Applies to:

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

Symptoms

User encountered following error while accepting the incoming E2B R3 report -

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

 

 

 

Following error was logged in Utilities -> Logs -> View Error Log screen -

  

:- ORA-00957: duplicate column name ORA-06512:
at "ARGUSDBA.PKG_UTL_SQL", line 73 ORA-06512:
at "ARGUSDBA.PKG_UTL_SQL", line 82
Bind Variables::SEQ_NUM = XXX ACT_TAKEN_ID = XXX CASE_ID = XXX DRUG_AUTH_COUNTRY_ID = XXX MISUSE = XXX OBTAIN_DRUG_COUNTRY_ID = XXX OFF_LABEL_USE = XXX SORT_ID = XXX
SQL:UPDATE CASE_PROD_DRUGS SET DRUG_AUTH_COUNTRY_ID = :DRUG_AUTH_COUNTRY_ID,ACT_TAKEN_ID = :ACT_TAKEN_ID,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: SQL673
PKG_CONSOLE_COMMON.P_ERROR_LOG18
PKG_UTL_SQL.P_LOG_SQL_ERROR87
PKG_UTL_SQL.F_EXECUTE_SQL3102
ICSR_CASE_CREATE_R3.POPULATE_REPEATER_DATA2038
ICSR_CASE_CREATE_R3.POPULATE_CASE_PRODUCT630
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.