How to mass delete Compensation published back records from Employee Central

[xavierlegarrec]

Overview

The Compensation publish back feature allows Compensation administrators to send back in one click to Employee Central (with a new effective date) all salary information reviewed by planners during the annual compensation cycle.

 

 

Reasons for this topic

During testing phases of an implementation we need to be able to run several mass publish backs of data to Employee Central from the same Salary planning template in order to confirm that all employees across all entities get published back to EC correctly.

 

 

Problem 

Depending on the way we had to design the publish back within the Compensation worksheet (which mainly depends on the complexity of the recurring pay components structure in EC as well as whether our customer decided to use Annualized planning or Rate-Type planning), we may encounter several error messages when trying to mass publish back a second time to Employee Central.

Even if we change the publish back date AND the publish back amount, our second publish back may fail with error messages such as "No value change" or "Change not allowed on second publish back" in Monitor Compensation Jobs.

The only workaround to those error messages would be for us to manually delete in each employee's profile the published back record then rerun the publish back.

 

 

Solution

In the recording below, Mustafa Nusrath (Employee Central Senior Business Process Consultant at SAP) guides us through the steps needed to mass delete all records published back in EC after our first publish back so we can start fresh for our second run :

The steps are :

1. Running an Adhoc report to find all published back records


2. Taking the information from that report and pasting it into the Employee Central import file for the Compensation Porlet


3. Importing the file and spot checking in Employee Central that the records were correctly deleted.

 

 

Conclusion

This video only explains how to mass delete records stored in the Compensation portlet of Employee Central. Feel free to reach out to the Employee Central consultant assigned to your implementation in case you would like to remove Job Information records (employees promoted during the compensation cycle) as well.

All materials in this article were inspired by recent implementations that are now live. Please highlight if you see anything that needs to be corrected or if you have encountered easier ways to meet customer requirements on this particular topic.

 

Additional links :

• Delete Pay Components Using Integration Center

 

 

—

All the best,

Xavier

 

 

 

(If you found this blog useful please consider giving it a Like)

[SreelathaN]

Great Xavirer !

[xavierlegarrec]

If you encounter the following error message when validating the import file :

Then you need to do this (Admin Center > Manage Data) :

Then reimport your file.

[xavierlegarrec]

If you are trying to mass delete non recurring pay components, the process is not exactly the same although very similar :

Step 1 : Create a table ad hoc report with domain “Non-Recurring Compensation (as of date)” :

Step 2 : In the report select all fields available inside “Pay Component Non Recurring”

Step 3 : Run the report from the Report Center and make sure to pick dates that comprise the publish back date that was used to publish back Bonus payments to EC.

Step 4 : Get the import template from Admin Center > Manage Employees > Import Employee Data

Step 5 : Build an import file the following way (to delete the bonus payment, enter DELIMIT in the operation column).

Step 6 : Validate the file then import it (both actions are done in Admin Center > Manage Employees > Import Employee Data > section Pay Component Non Recurring

[former_member44427]

Hi Xavier, thanks for your sharing!

May I ask you a relevant question: we have published 100 employees' new salary and 10 employees' new position to Employee Central. But we found one emloyee's new position is not correct. In this case, do we need to delete all these employees' compensation information and job information records in Employee Central?

Looking forward to your reply!

[xavierlegarrec]

Hi, I think I would rather advise manually adjusting this person's in Employee Central. You do not need to remove all published back information for everyone else. All the best, Xavier

[former_member44427]

Thanks Xavier very much for your advice!