SAP Knowledge Base Article - Preview

2981010 - How to trigger a full load replication - Master Data and Org. Assignment Replication


Your transformation template of replication program ECPAO_EE_ORG_REPL_QUERY is currently running on delta and sending a "last_modified_on" filter in the Compound Employee query, as below:

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-15T14:46:37Z') 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'

But you need to trigger a full load query once again.

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



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


SAP SuccessFactors HXM Suite all versions


ECPAO_EE_ORG_REPL_QUERY, bib, erp, replication, employee, master data, org assignment, last modified, last_modified_on, ECPAO_QRY_ADM, on prem, on-prem, premise, erp, ecc, sap, sf, successfactors, reset, full load, initial load, ftsd, ECPAO_RESET_QRY_ADM, ECPAO_QRY_ADM, ECPAO_QRY_ADMDT , 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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.