This discussion is archived
1 Reply Latest reply: Dec 10, 2012 7:56 AM by 979023 RSS

Initial load of data to UCM for Customer Hub PIP

971716 Newbie
Currently Being Moderated
Hi,

What is the recommended approach to have XREF tables populated during an initial load to UCM (via EIM), when the Accounts already exist in Siebel CRM?

Our approach as of now, using EIM, is as follows:
1) Set required customer information in EIM_UCM_ORG
2) Look up the customer's existing Row_ID in Siebel, and populate EIM_UCM_ORG.EXT_SYSTEM_NUM and EIM_UCM_ORG.UCM_EXT_ID) accordingly
3) Run the EIM job and UCM Batch Process to import the customer into UCM

The account then appears in UCM with the correct reference to siebel/row_id under the "external account IDs" tab. HOWEVER, it also contains a reference to a newly created duplicate record for that account in Siebel. Looking at the xref tables, there is no reference to the existing Siebel/row_id specified in the EIM batch load, and our hypothesis is that this is the reason the account cannot be found (and a duplicated is created). What we want to achieve here is to tell UCM that the accounts we are inserting do infact already exist in Siebel CRM, and can be identified by the row_id that we pass along.

The relevant system versions are Customer Hub PIP 11g with AIA 3. Siebel CRM and Siebel UCM are on patch 8.1.1.7 (and pertinent ACRs have been incorporated in the two Siebel instances).

Any hints or suggestions on how to approach this would be appreciated



-M

Edited by: 968713 on Nov 1, 2012 5:05 AM

Edited by: 968713 on Nov 1, 2012 5:05 AM

Edited by: 968713 on Nov 1, 2012 5:06 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points