EIM error ORA-00904 while importing Accounts

(Doc ID 858237.1)

Last updated on JULY 20, 2016

Applies to:

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


Statement of what the issue is

Siebel/Database: SIA [20417]/Oracle

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.


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