Technical Articles
How to mass delete Compensation published back records from Employee Central
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 :
- Running an Adhoc report to find all published back records
- Taking the information from that report and pasting it into the Employee Central import file for the Compensation Porlet
- 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 :
Great Xavirer !
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.
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