SAP Knowledge Base Article - Public

2375294 - How to use the Compound Delete for Employee Central (Mass Delete Grid Portlet Data)

Symptom

You can delete information like email, phone, address, national ID, and so on for an active user or a person using the Compound Delete template. There are several use cases for the Compound Delete feature, and some of the questions with are resolved by leveraging this import feature are mentioned below:

  • How do I delete the following data for users via Import?
    • Job Relationships
    • Pay Component Non Recurring
    • Addresses
    • Email Information
    • Phone Information
    • National ID Information
  • We have tried to use "DELIMIT" option to delete Job Relationships, Pay Component Non Recurring, Addresses, Email Information, Phone Information, National ID Information data without success
  • We have an orphaned Person ID in the system that needs purging

Environment

Employee Central

Resolution

There is a Compound Delete (Delete All Records) Feature which enables user to delete all the records for a given User Id/Person Id External for specific HRIS element data.

  • Job Relationships
  • Pay Component Non Recurring
  • Addresses
  • Email Information
  • Phone Information
  • National ID Information
  • Biographical Info (please note that personInfo can only be deleted via Compound Delete in a specific scenario - please refer to article 2438812 > section "How to use the Compound Delete to delete an orphaned Person ID" for more information)

See Below: HRIS Element ID

HRIS Element Identifier
Job Relationships jobRelationsInfo
Pay Component Non Recurring payComponentNonRecurring
homeAddress homeAddress
Email Information emailInfo
Phone Information phoneInfo
National ID Information nationalIdCard
Biographical Info personInfo

More information regarding the Compound Delete feature can be found in the Employee Central Imports Admin Guide > Working with Data Imports > Working with Employee Data > Deleting Employee Data

 

How do I enable the Compound Delete feature?

To enable the Compound Delete feature for Import Employee Data, you must:

  1. Navigate to Provisioning > Company Settings
  2. Selected "Enable Compound Delete"
  3. Save

Enable Compound Delete.png

Once enabled, the Compound Delete Template can be downloaded and imported from Admin Center > Import Employee Data.

 

Validations:

The following validations are performed when using this import feature:

  1. User-Id/Person-Id-External should not be invalid.
  2. Hris-Element-Type should not be invalid (either wrong name or not supported - see the current list of support HRIS Elements in the handbook here).
  3. Duplicates with respect to User-Id/Person-Id-External and Hris-Element-Type will report an error.
  4. If one of the records for a given User-Id/Person-Id-External reports error, none of the other Hris-Element-Type will pass validation for that User-Id/Person-Id-External.

 

Additional Information:

  1. Threshold for the Delete operations is 5000 i.e. if the import file contains more than 5000 records then it will be processed asynchronously.

 

Purging orphaned Person ID's from the system:

Please refer to the article 2438812 - Check Tool: How to use Check Tool to check if there are any Orphan Person ID Externals in the system. (CORE_JI_CHECK_03) - for further information

See Also

  • 2438812 - Check Tool: How to use Check Tool to check if there are any Orphan Person ID Externals in the system. (CORE_JI_CHECK_03)
  • 2287959 - Person ID External already exists

Keywords

Import Employee Data, Mass Delete, Compound Delete, grid portlet, ec, employee central,HRIS Element ID, HRIS Element, Orphan , KBA , LOD-SF-EC-EDP , Employee Data Imports , Problem

Product

SAP SuccessFactors HCM Core 1605

Attachments

CompoundDeleteImportTemplate_test.csv