SAP Knowledge Base Article - Public

2639025 - External ID XYZ already exists, when replicating Org Units from Staging Area.

Symptom

You are replicating Organizational units from CRM on Premise to C4C, the message is successful in Webservice message monitoring but the replication fails in Staging Area with the error.

External ID XYZ already exists. XYZ ix the ID of the AssociatedOrgCentreId coming in the payload.

Environment

  • Cloud for Customer
  • ERP
  • Customer Relationship Management

Reproducing the Issue

  • Go to Administration Work Centre.
  • Click on the Hyper link Organizational Structure Replication.
  • Find the failed replication request and click on the Hyperlink of the Application Log ID.
  • Go to the results tab and expand all.

Here you will see the error. External ID XYZ already exists.

In The payload search for the ID mentionned in the error example XYZ, you will find this ID as <AssociatedOrgCentreId>XYZ</AssociatedOrgCentreId> under multiple <OrganisationCentreID>.

You can also verify as below:

  • Go to Administration Work Centre.
  • Click on the Hyper link Organizational Structure Replication.
  • Find the failed replication request.
  • Click on Edit.
  • Under the Remote Organizational ID column search for the ID found in the payload <OrganisationCentreID>.
  • Select it and click at the buttom on the associated Org Centre.
  • Here you will find the XYZ ID.
  • Do the same for the multiple entries found in the payload.
  • you will find XYZ used as associated org Centre for multiple Remote Organizational ID which is not supported in C4C.

 

Cause

C4C doesn't allow the creation since C4C doesn't support same Orgs assigned (AssociatedOrgCentreId) to 2 different Org units as it considers them as ERP equivalent of the CRM orgs and hence the replication request is failing.

Resolution

Since C4C does not support the multiple ERP Orgs this has to be filtered in CRM only.
You can implement this change in the enhancement: CRMPCD_ORG_UNIT_REPLICATION
In the CS org Units you need to filter out the ERP_ORG_DETAILS.
If you dont need the ERP orgs in C4C you can clear this entire segment.
Else only one of them have to be sent. Based on the ORG_ATTRIBUTES :
IS_SALES_ORG, IS_SALES_OFFICE and IS_SALES_GROUP for the particular org, which ever is set to true the corresponding ERP_ORG_UNIT attributes SA_ATTRIBUTE which has R3_SA_ORG, R3_SA_OFF, R3_SA_GRP has to be sent.

Keywords

Org Unit Replication, CRM Org Units, Staging Area, Organizational Structure Replication. , KBA , LOD-CRM-INT-CRM , Integration of C4C with CRM , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions