0 Replies Latest reply: Aug 11, 2010 5:52 AM by 773387 RSS

    UCM: Unable to link contacts to account using EIM

    773387
      Hi,

      I have some problems importing contacts into UCM 8.1 and linking them to accounts.

      I have populated EIM_UCM_CON.PAR_UCM_ACCNT_UID with EIM_UCM_ORG.UCM_UID, however, when I run the UCM batch job to populate the CRM both the account and contact record get created in CRM but the relationship does not get established. I have managed to link Address to Accounts the similar method described above by populating the 'PAR_UCM_ACCNT_UID' in EIM_UCM_ADRPER table, I am unable to work out why it doesn’t work for Account and Contacts.

      Is it even possible with EIM_UCM_CON or would I have to use EIM_UCM_ORGCHILD? If I had to use EIM_UCM_ORGCHILD, would the data cleansing work anyway?
      Is it essential to set a specific xxx_FLG field?
      I tried PR_CHILD_FLG, as I also needed it to link addresses to accounts, but didn't work.

      Columns populated in EIM_UCM_CON :
      IF_ROW_BATCH_NUM, ROW_ID, UCM_UID, EXT_SYSTEM_NUM, UCM_EXT_ID, IF_ROW_STAT, UCM_TYPE_CD, FIRST_NAME, LAST_NAME, INTEGRATION_ID, PAR_UCM_OBJTYPE_CD, PAR_UCM_ACCNT_UID, PR_CHILD_FLG


      Thanks for your help
      Sebastian

      Edited by: Sebastian on 11.08.2010 05:52