SAP Knowledge Base Article - Public

3434930 - Error in Compound Employee when replicating Employee Data: The effective end date filter is outside of the retention period

Symptom

You wish to know why an employee replication is failing with an error like the following. Such an error can impact Compound Employee API segments such as personal_information or employment_information, and may be visible via API logs, tracking tools such as ERP's SLG1 or your middleware (BTP/CPI):



                        <log_item>
                            <per_person_uuid>ABCDEFGHIJKLMNOPQRSTUVWXYZ</per_person_uuid>
                            <person_id>123456</person_id>
                            <person_id_external>000001</person_id_external>
                            <code>COMPOUND_EMPLOYEE/EFFECTIVE_END_DATE_FILTER_IN_PURGE_PERIOD</code>
                            <severity>ERROR</severity>
                            <message_text>The effective end date filter is outside of the retention period of entity "employment_information" that starts on 2024-01-01. Please use an effective end date filter greater than or equal to 2024-01-01.</message_text>
                        </log_item> 


Environment

SAP SuccessFactors Compound Employee

Reproducing the Issue

This error is particularly common in two scenarios:

1) You used the business purge to remove old records from the employee’s history, but the Full Transmission Start Date (FTSD) used in your integration is lower than the used retention period.

2) You rehired a person into a new employment and purged one of the employments completely.

Cause

Purge Validation protects the ERP system from deleting data which was purged in EC. This way, it is not possible to replicate a person if effective-dated master data is not completely available anymore back until the FTSD. Also remaining employments can’t be replicated anymore if another employment of the same person has been purged as the validation is performed on person level.

This can be mitigated by switching to Business Integration Builder (BIB) based replication with activating the option to use DRTMPurgeStatusOverview where the purge evaluation is done in ERP instead of EC.

 

Resolution

Both options from a Compound Employee API perspective are explained in Data Purge Handling | SAP Help Portal, please see below for the available alternatives, based on your scenario:

 

If using BIB:

 

If not using BIB:

Do not purge master data which is valid after the FTSD.

Do not rehire into existing person if you plan to purge employments of the same person, create a new person instead.


Additionally, please consider the following information (cf. See Also, below):

Based on 3250816 (Maintenance for the product SFSF EC INTEGRATION – Add-on PA_SE_IN),
Transitioning from Non-BIB to BIB-Based Employee Data Replication from Employee Central in PA_SE_IN and
Upgrading from PA_SE_IN to ECS4HCM for Data Migration and Replication to Employee Central we recommend you plan the move from the non-BIB based to the BIB-based replication.

See Also

3048059    Error: "Data was not replicated successfully. Check Full Transmission Start Date." - The effective end date filter is outside of
2557861    [1802] GDPR (Global data Protection regulation) Compliance - validation check for partial purged employee Data
3250816    (Maintenance for the product SFSF EC INTEGRATION – Add-on PA_SE_IN)
Transitioning from Non-BIB to BIB-Based Employee Data Replication from Employee Central in PA_SE_IN
Upgrading from PA_SE_IN to ECS4HCM for Data Migration and Replication to Employee Central
Using Individual Full Transmission Start Date

Keywords

COMPOUND_EMPLOYEE/EFFECTIVE_END_DATE_FILTER_IN_PURGE_PERIOD, The effective end date filter is outside of the retention period of entity "employment_information", The effective end date filter is outside of the retention period of entity "personal_information", Please use an effective end date filter greater than or equal to, CE, CompoundEmployee, Compound_Employee, rehire, re-hire, hire, EC, replication, BIB, non-BIB, legacy, FTSD , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , Problem

Product

SAP SuccessFactors HCM all versions