SAP Knowledge Base Article - Public

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

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 &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'
</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:

  1. Go to ECPAO_RESET_QRY_ADM transaction
  2. Search for the transformation template you want to trigger the full load and select the "Last Modified Query" entry of it



  3. Click on "Delete Query" button to delete the entry
  4. 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 &gt;= to_date('2019-01-01') AND hiringNotCompleted = 'false'
</queryString>

No "last_modified_on" filter, hence a full load.

See Also

Resetting Employee Master Data and Organizational Assignment Queries

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-CPI-ERP , Standard SF to SAP ERP or S/4HANA Integration using CPI , LOD-SF-INT , Integrations , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , How To

Product

SAP SuccessFactors HXM Suite all versions