Unable To Accept Imported ICSR With ORA-00957 Duplicate Column Name
(Doc ID 3015174.1)
Last updated on APRIL 11, 2024
Applies to:
Oracle Life Sciences Argus Safety - Version 8.2.3.1 and laterInformation in this document applies to any platform.
Symptoms
When trying to accept ICSR in (menu) Reports > Incoming ICSR Reports, system does not accept this ICSR.
The following errors are displayed in (menu) Utilities > Logs > View Error Log.
Argus Safety.COM :- Oracle error 1 occurred.
ORA-00957: duplicate column name
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 865
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 1695
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 88
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 7
3ORA-06512: at "SYS.DBMS_SQL", line 11
99ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 31
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 82
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 1601
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 721
ORA-06512: at line 1
SQL: begin ICSR_CASE_CREATE_R3.Main_Create_Case_R3(:P_LOAD_REPORT_ID, :P_USER_ID, :P_DIFF_RPT_GEN_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: 153005432073889851386
73 PKG_CONSOLE_COMMON.P_ERROR_LOG
1 __anonymous_block
ORA-00957: duplicate column name
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 865
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 1695
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 88
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 7
3ORA-06512: at "SYS.DBMS_SQL", line 11
99ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 31
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 82
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 1601
ORA-06512: at "ESM_OWNER.ICSR_CASE_CREATE_R3", line 721
ORA-06512: at line 1
SQL: begin ICSR_CASE_CREATE_R3.Main_Create_Case_R3(:P_LOAD_REPORT_ID, :P_USER_ID, :P_DIFF_RPT_GEN_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: 153005432073889851386
73 PKG_CONSOLE_COMMON.P_ERROR_LOG
1 __anonymous_block
. :- ORA-00957: duplicate column name
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 73
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 31
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 82
Bind Variables:CASE_ID = xxx
NARRATIVE = SQL:INSERT INTO CASE_NARRATIVE(NARRATIVE,NARRATIVE, CASE_ID) VALUES (:NARRATIVE,:NARRATIVE,:CASE_ID)
PL/SQL Call Stack: 17793088510800280005
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
18 PKG_UTL_SQL.P_LOG_SQL_ERROR
87 PKG_UTL_SQL.F_EXECUTE_SQL
1601 ICSR_CASE_CREATE_R3.POPULATE_CASE_TABLE
721 ICSR_CASE_CREATE_R3.MAIN_CREATE_CASE_R3
1 __anonymous_block
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 73
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 31
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 82
Bind Variables:CASE_ID = xxx
NARRATIVE = SQL:INSERT INTO CASE_NARRATIVE(NARRATIVE,NARRATIVE, CASE_ID) VALUES (:NARRATIVE,:NARRATIVE,:CASE_ID)
PL/SQL Call Stack: 17793088510800280005
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
18 PKG_UTL_SQL.P_LOG_SQL_ERROR
87 PKG_UTL_SQL.F_EXECUTE_SQL
1601 ICSR_CASE_CREATE_R3.POPULATE_CASE_TABLE
721 ICSR_CASE_CREATE_R3.MAIN_CREATE_CASE_R3
1 __anonymous_block
Or
. :- ORA-00957: duplicate column name
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 73
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 31
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 82
Bind Variables:CASE_ID = xxx
NARRATIVE = NARRATIVE_J = SQL:INSERT INTO CASE_NARRATIVE(NARRATIVE_J,NARRATIVE,NARRATIVE, CASE_ID) VALUES (:NARRATIVE_J,:NARRATIVE,:NARRATIVE,:CASE_ID)
PL/SQL Call Stack: 15519921781882866576
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
18 PKG_UTL_SQL.P_LOG_SQL_ERROR
87 PKG_UTL_SQL.F_EXECUTE_SQL
1553 ICSR_CASE_CREATE_R3.POPULATE_CASE_TABLE
710 ICSR_CASE_CREATE_R3.MAIN_CREATE_CASE_R3
1 __anonymous_block
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 73
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 31
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 82
Bind Variables:CASE_ID = xxx
NARRATIVE = NARRATIVE_J = SQL:INSERT INTO CASE_NARRATIVE(NARRATIVE_J,NARRATIVE,NARRATIVE, CASE_ID) VALUES (:NARRATIVE_J,:NARRATIVE,:NARRATIVE,:CASE_ID)
PL/SQL Call Stack: 15519921781882866576
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
18 PKG_UTL_SQL.P_LOG_SQL_ERROR
87 PKG_UTL_SQL.F_EXECUTE_SQL
1553 ICSR_CASE_CREATE_R3.POPULATE_CASE_TABLE
710 ICSR_CASE_CREATE_R3.MAIN_CREATE_CASE_R3
1 __anonymous_block
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 |