EIM error ORA-00904 while importing Accounts
Last updated on JULY 20, 2016
Applies to:Siebel Enterprise Integration Manager - Version 220.127.116.11 SIA  to 18.104.22.168  [Release V8]
Information in this document applies to any platform.
Statement of what the issue is
Siebel/Database:22.214.171.124 SIA /Oracle 10.2.0.4
You have run the upgrade to V8.x, you are currently importing Accounts through EIM using EIM_ACCOUNT Table.
EIM import is failing with the following error:
"ORA-00904: "T_ORG_BU__RID": invalid identifier"
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