My Oracle Support Banner

Unable to Accept a Follow-up Report With Error : Duplicate Column Name ORA-06512 (Doc ID 2734792.1)

Last updated on DECEMBER 08, 2020

Applies to:

Oracle Argus Interchange - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms


Via [Reports] > E2B Pending Screen, unable to accept an E2B Follow-up report with error "duplicate column name ORA-06512"

Review of the Error logs shows:

:- ORA-00957: duplicate column name
ORA-06512: at "xxxx.PKG_UTL_SQL", line 73
ORA-06512: at "xxx.PKG_UTL_SQL", line 82
Bind Variables::
SEQ_NUM = 32612411
CASE_ID = XXXXX
CODE_STATUS = 1
DICT_ID = XXX
HLGT = Metabolic, nutritional and blood gas investigations
HLGT_CODE = 10027432
HLT = Carbohydrate tolerance analyses (incl diabetes)
HLT_CODE = 10007217
INFO_AVAILABLE = 0
LAB_TEST_NAME = Blood glucose
LLT = Blood glucose
LLT_CODE = 10005553
NOTES =
PT_CODE = 10005553
SOC = Investigations
SOC_CODE = 10022891
SORT_ID = 1
TEST_DATE = 15-JUN-2020 00:00:00
TEST_DATE_PARTIAL = 2020
TEST_DATE_RES = 5
TEST_REPTD = Blood sugar

SQL:INSERT INTO CASE_LAB_DATA(TEST_DATE,TEST_DATE,TEST_DATE_PARTIAL,TEST_DATE_PARTIAL,TEST_DATE_RES,TEST_DATE_RES,TEST_REPTD,TEST_REPTD,PT_CODE,PT_CODE,LLT_CODE,LLT_CODE,HLT_CODE,HLT_CODE,HLGT_CODE,HLGT_CODE,SOC_CODE,SOC_CODE,LLT,LLT,HLT,HLT,HLGT,HLGT,SOC,SOC,DICT_ID,DICT_ID,CODE_STATUS,CODE_STATUS,LAB_TEST_NAME,LAB_TEST_NAME,NOTES,NOTES,INFO_AVAILABLE,INFO_AVAILABLE, CASE_ID, SEQ_NUM, SORT_ID) VALUES (to_date(:TEST_DATE, 'DD-MON-YYYY HH24:MI:SS'),to_date(:TEST_DATE, 'DD-MON-YYYY HH24:MI:SS'),:TEST_DATE_PARTIAL,:TEST_DATE_PARTIAL,:TEST_DATE_RES,:TEST_DATE_RES,:TEST_REPTD,:TEST_REPTD,:PT_CODE,:PT_CODE,:LLT_CODE,:LLT_CODE,:HLT_CODE,:HLT_CODE,:HLGT_CODE,:HLGT_CODE,:SOC_CODE,:SOC_CODE,:LLT,:LLT,:HLT,:HLT,:HLGT,:HLGT,:SOC,:SOC,:DICT_ID,:DICT_ID,:CODE_STATUS,:CODE_STATUS,:LAB_TEST_NAME,:LAB_TEST_NAME,:NOTES,:NOTES,:INFO_AVAILABLE,:INFO_AVAILABLE,:CASE_ID,:SEQ_NUM,:SORT_ID)PL/SQL Call Stack:  SQL673        PKG_CONSOLE_COMMON.P_ERROR_LOG18         PKG_UTL_SQL.P_LOG_SQL_ERROR87         PKG_UTL_SQL.F_EXECUTE_SQL3030       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

 

 

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


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