EIM error ORA-00904 while importing Accounts
Last updated on JULY 20, 2016
Applies to:Siebel Enterprise Integration Manager - Version 126.96.36.199 SIA  to 188.8.131.52  [Release V8]
Information in this document applies to any platform.
Statement of what the issue is
Siebel/Database:184.108.40.206 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
Million Knowledge Articles and hundreds of Community platforms