EIM Import of Accounts and Addresses (Doc ID 525817.1)

Last updated on MAY 01, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.8.2 SIA [19213] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Professional)
Version: 7.8.2 [19213]
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***


Symptoms

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.

Thank you.

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