SAP Knowledge Base Article - Public

2980935 - How to force the replication of employees - Master Data and Org. Assignment Replication

Symptom

Your ERP replication is currently running the replication program ECPAO_EE_ORG_REPL_QUERY using delta and you need to replicate some employees whose master data (or organizational assignments if applicable) was changed after a specific date.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HXM Suite
  • Employee Master Data and Organizational Assignment Replication
  • ERP On-Premise

Resolution

On SF side, you can do the following:

  1. Go to Data Replication Monitor
  2. Select the employee you want to replicate
  3. Click on Send button

This will make the employee be picked up by the next replication query that reaches SF.

On the ERP side you have some other options through SE38 > ECPAO_EE_ORG_REPL_QUERY.

You can specify the Employee ID of the employees you want to replicate, using the External Employee ID field:

You can also use the Change Date field. This field will change the "last_modified_on" parameter of the query. Let's say you put value 13.10.2020:

This will send the below Compound Employee query to SF:

<queryString>
SELECT address_information,alternative_cost_distribution,associated_employee_information,compensation_information,deduction_recurring,dependent_information,email_information,employment_information,global_assignment_information,job_information,national_id_card,paycompensation_recurring,person,personal_information,phone_information from CompoundEmployee WHERE replicationTargetSystem = 'S4ACLNT200' AND replicationContentType IN ('EMPLOYEE_MASTER_DATA','EMPLOYEE_ORG_ASSIGNMENT') AND last_modified_on &gt;= to_datetime('2020-10-13T00:00:00Z') AND company IN ('1710') AND selectFromDate = to_date('2019-01-01','yyyy-MM-dd') AND isContingentWorker IN ('0','1') AND effective_end_date &gt;= to_date('2019-01-01') AND hiringNotCompleted = 'false
</queryString>

This will return all employees that were changed since 2020-10-13.

Note: The Change Date value must not be more than three months in the past.

See Also

Configuring the Query Program for Employee Master Data and Organizational Assignment Replication

Rescheduling Employee Data Replication

Keywords

ECPAO_EE_ORG_REPL_QUERY, bib, erp, replication, employee, master data, org assignment, reset, last modified, last_modified_on, ECPAO_QRY_ADM, on prem, on-prem, premise, erp, ecc, sap, sf, successfactors, force, sync, manual, manually  , KBA , LOD-SF-INT-DRM , Data Replication Monitor , LOD-SF-INT , Integrations , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , LOD-SF-INT-CPI-ERP , Standard SF to SAP ERP or S/4HANA Integration using CPI , How To

Product

SAP SuccessFactors HXM Suite all versions

Attachments

Pasted image.png
Pasted image.png