Error Loading Customer Initial Load Using ODI (Doc ID 1419468.1)

Last updated on OCTOBER 20, 2016

Applies to:

Siebel CRM Integration Pack for Oracle Order Management: Order to Cash - Version 3.1 and later
Information in this document applies to any platform.

Symptoms

On : 3.1.1 version, Initial Customer Data Load

When attempting to load data using the standard ODI bulkload process provided by oracle,
the following error occurs.

ERROR
-----------------------

ODI-1217: Session OracleEbiz_to_XREF_to_EIM (8001) fails with return code 942.
ODI-1226: Step 5_Ebiz_Cust_CustPar_PARTYID_XREF_In fails after 1 attempt(s).
ODI-1240: Flow 5_Ebiz_Cust_CustPar_PARTYID_XREF_In fails while performing a Loading operation. This flow loads target table XREF_DATA.
ODI-1227: Task SS_0 (Loading) fails on the source ORACLE connection OracleEbiz_DS.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist



In ODI Operator Tab for the failed sessions against the Task: "Loading - SS_0 - Load data" the following error can be seen:

ODI-1227: Task SS_0 (Loading) fails on the source ORACLE connection OracleEbiz_DS.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
...

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