My Oracle Support Banner

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

Last updated on APRIL 18, 2023

Applies to:

Siebel CRM - Version 8.1.1 [21112] and later
Information in this document applies to any platform.
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

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
References


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