Symptom
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:
<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 >= 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'
</queryString>
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.
Environment
- SAP SuccessFactors HXM Suite
- Employee Master Data and Organizational Assignment Replication
- ERP On-Premise
Resolution
You can follow these steps to set your transformation template to run a full load:
- Go to ECPAO_RESET_QRY_ADM transaction
- Search for the transformation template you want to trigger the full load and select the "Last Modified Query" entry of it
- Click on "Delete Query" button to delete the entry
- Confirm the pop up message
After deleting the "Last Modified Query" entry, the transformation template will once again send a full load query to SF when executed for the first time.
This was the Compound Employee query sent to SF API after deleting the "Last Modified Query" entry:
<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 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'
</queryString>
No "last_modified_on" filter, hence a full load.
See Also
Keywords
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