Error While Accepting E2B File
(Doc ID 2809450.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
While accepting E2B file which is followup the below error is observed:
Reports > ICSR Pending
[Accept ICSR] button
Argus Safety.COM :- Oracle error 1 occurred.
ORA-00957: duplicate column name
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 847
ORA-06512: at line 1SQL: begin ICSR_CASE_CREATE_R3.Main_Create_Case_R3(:P_LOAD_REPORT_ID, :P_USER_ID, :P_CASE_NUM, :P_VIEW_WARNINGS, :P_NOTES, :P_NOTES_ID, :P_RESULT, :PO_CASE_IDN, :PO_SEQ_NUM, :PO_CEA_LISTEDNESS_STR, :P_CASE_ID, :P_DEBUG); end;
PL/SQL Call Stack: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG1 __anonymous_block
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 = 2068958CASE_ID = 653004NOTES = SORT_ID = 103SQL:UPDATE CASE_LAB_DATA SET NOTES = :NOTES,NOTES = :NOTES WHERE CASE_ID = :CASE_ID AND SEQ_NUM = :SEQ_NUMPL/SQL Call Stack: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG18 PKG_UTL_SQL.P_LOG_SQL_ERROR87 PKG_UTL_SQL.F_EXECUTE_SQL3046 ICSR_CASE_CREATE_R3.POPULATE_REPEATER_DATA2360 ICSR_CASE_CREATE_R3.POPULATE_CASE_REPEATAR_TABLE631 ICSR_CASE_CREATE_R3.MAIN_CREATE_CASE_R31 __anonymous_block
ORA-00957: duplicate column name
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 847
ORA-06512: at line 1SQL: begin ICSR_CASE_CREATE_R3.Main_Create_Case_R3(:P_LOAD_REPORT_ID, :P_USER_ID, :P_CASE_NUM, :P_VIEW_WARNINGS, :P_NOTES, :P_NOTES_ID, :P_RESULT, :PO_CASE_IDN, :PO_SEQ_NUM, :PO_CEA_LISTEDNESS_STR, :P_CASE_ID, :P_DEBUG); end;
PL/SQL Call Stack: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG1 __anonymous_block
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 = 2068958CASE_ID = 653004NOTES = SORT_ID = 103SQL:UPDATE CASE_LAB_DATA SET NOTES = :NOTES,NOTES = :NOTES WHERE CASE_ID = :CASE_ID AND SEQ_NUM = :SEQ_NUMPL/SQL Call Stack: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG18 PKG_UTL_SQL.P_LOG_SQL_ERROR87 PKG_UTL_SQL.F_EXECUTE_SQL3046 ICSR_CASE_CREATE_R3.POPULATE_REPEATER_DATA2360 ICSR_CASE_CREATE_R3.POPULATE_CASE_REPEATAR_TABLE631 ICSR_CASE_CREATE_R3.MAIN_CREATE_CASE_R31 __anonymous_block
After deselecting all the lab data in incoming file the user was able to import.
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 |