How to mass delete Compensation published back records from Employee Central
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.
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.
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.
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.