EIM_CON_DTL Export - "ORA-00957: Duplicate Column Name" Error (Doc ID 1539978.1)

Last updated on DECEMBER 09, 2016

Applies to:

Siebel CRM - Version 8.1.1 [21112] and later
Information in this document applies to any platform.
***Checked for relevance on 10-Nov-2014***

Customer attempted to export Contact details using EIM_CON_DTL.

When they run the export we get a "ORA-00957: duplicate column name" error generated by the following SQL:

UPDATE SIEBEL.EIM_CON_DTL IT
SET (CON_BI,
CON_PERSON_UID,
CON_PRIV_FLG,
CON_PRIV_FLG) =
(SELECT BT.BU_ID,
BT.PERSON_UID,
BT.PRIV_FLG,
BT.PRIV_FLG
FROM SIEBEL.S_CONTACT BT
WHERE (BT.ROW_ID = IT.T_CONTACTTN_PARROW))
WHERE (T_CONTACTTN_PARROW IS NOT NULL AND
IF_ROW_BATCH_NUM = ?)

There do not appear to have been any client customizations made to the EIM_CON_DTL mappings.

Symptoms

 EIM export task from interface table EIM_CON_DTL failed with error message [DataDirect][ODBC Oracle driver][Oracle]ORA-00957: duplicate column name

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms