EIM error ORA-00904 while importing Accounts

(Doc ID 858237.1)

Last updated on JULY 20, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 8.0.0.4 SIA [20417] to 8.1.1.9 [23016] [Release V8]
Information in this document applies to any platform.

Symptoms

Statement of what the issue is
Environment
=========

Siebel/Database:8.0.0.4 SIA [20417]/Oracle 10.2.0.4

You have run the upgrade to V8.x, you are currently importing Accounts through EIM using EIM_ACCOUNT Table.

Error message
=========
EIM import is failing with the following error:

"ORA-00904: "T_ORG_BU__RID": invalid identifier"

Expected behavior
============

The upgrade process must not change or drop any Temp columns neither on database nor on the repository. The column is a standard default column and should be existing on EIM_ACCOUNT Table so that EIM can run successfully.

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