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 >= 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 >= 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
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 pageThis 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.