Symptom
After completing a DRTM Master Data Purge, when downloading Preview Report, there is a column in .csv file with NOTES: "There is no exit date assigned to this user".
Environment
SAP SuccessFactors HCM Suite
Reproducing the Issue
- Login to instance
- Go to Data Retention Management
- Create New Purge Request
- Select Purge request type : DRTM Master Data Purge
- Select user or Upload a list of users
- Add Approver
- Launch Immediately
- Go to Purge Request Monitor
- Select Requests Pending Final Approval Tab
- Approve the Request
- Go to Purge Progress & Results
- See Status as Completed
- When downloading Preview Report, see a column in .csv file with NOTES: There is no exit date assigned to this user.
Cause
Cause #1:
CompanyExitDate is not maintained for the purge user in UDF.
Cause #2:
Ignore data retention time configuration for this purge request was not flagged.
Resolution
For Cause #1:
Follow below steps:
- Admin Center
- Data Inspector
- Table_EMP_EMPLOYMENT_INFO
- Define Filter Criteria
- Users Sys ID -> Equals -> Userid
- Show Data
- Check value of "Is EC Record"
- If "Is EC Record" is 0, then the user is not an EC user. Those users must have CompanyExitDate records in UDF to be purged
- If "Is EC Record" is 1, the user is an EC user, and we must verify that an End Date is maintained in the EC table.
Refer to Help Portal - Syncing the Termination Date Between Employee Central and Standard User Fields to set up HRIS sync mapping between Employee Central and the standard user field <companyExitDate>.
For Cause #2:
When purging data for an individual or a list of inactive users, flag this option to ignore data retention times and purge data immediately with fewer restrictions: the DRTM Master Data Purge skips user's validations as country/region record and termination date record. For example: although a user's country/region record doesn't match the country names defined in the MDF object for country/region, the user's data can still be purged immediately.
- NOTE: When the "Upload a list" option is chosen, the Ignore checkbox only becomes available once the "Upload" button is clicked.
See Also
- Help Portal - Adding the CompanyExitDate Field to the User Record
- Help Portal - Syncing the Termination Date Between Employee Central and Standard User Fields
- KBA 2643327 - Missing 'Company Exit Date' Field in User Profile for DRTM
- KBA 2617614 - How to Configure companyExitDate Field under Manage Business Configuration
- KBA 2615360 - DRTM Master Data Purge for Inactive Users
Keywords
CompanyExitDate, Company Exit Date, DRTM Master Data Purge, SuccessFactors, Platform, LOD-SF-PLT, LOD-SF-EC, Is EC Record, Table_EMP_EMPLOYMENT_INFO, Data inspector, There is no exit date assigned to this user, ignore retention time, upload a list, bcui , KBA , LOD-SF-PLT-DRM , Data Retention Management , LOD-SF-EC-DRM , Data Retention Management - (DRM & DRTM) EC Data Only , Problem
SAP Knowledge Base Article - Public