EIM Import of Accounts and Addresses
Last updated on MAY 01, 2017
Applies to:Siebel Enterprise Integration Manager - Version 7.8.2 SIA  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Professional)
Version: 7.8.2 
Database: Microsoft SQL Server 2000 SP 2
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Microsoft Windows 2003 Server
This document was previously published as Siebel SR 38-3396271021.
***Checked for relevance on 16-Oct-2015***
I am trying to import a group of accounts, opportunities, contacts, and account addresses, however, I am having difficulties associating the addresses with their corresponding accounts and setting them as the primary.
I have searched the knowledgebase and have found multiple references to this issue, however, none of the provide a straightforward answer. I have tried all the suggestions provided to other people, but have no success in setting the primary address id (S_ORG_EXT.PR_ADDR_ID) using EIM.
I am looking for a straightforward answer to an seemingly simple question. Could you provide the EIM configuration necessary to load an account and an address, associate the address with the account, and set the address as the primary for the account?
Please provide the EIM tables and the import order I should use. If you can, please just provide the answer in this SR and don't refer me to other SR's since I have I believe I have looked at all of them and have not found the answer to this issue.
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