They wanted to change the salary basis from Monthly to Period (Biweekly). It is a common scenario that many company may change their Salary basis from monthly to biweekly or Bimonthly, but the interesting thing in this project is they wanted to modify the history salary information for all the employees from Monthly to Biweekly.
The first thing that came in my mind was the Auditing issue that we might run since we are touching the most sensitive information of the employee data (SALARY), But the HR Users clearly informed us they can provide us with the exact data that need to be loaded.
Another advantage was the customer is not using Oracle Payroll,Oracle HRMS system is not a transactional system
We followed the following approach
- Remove the salary proposal for the employee for whom we need to modify.
- Update the Assignment with the new Salary Basis in Correction mode
- Reload the salary with the same Change date as we unloaded
We used WebADI for unloading Salary information, updating assignment with the new salary basis and loading the salary proposal for the new salary basis.
We used WebADI custom Integrator with the following API
- HR_MAINTAIN_PROPOSAL_API.DELETE_SALARY_PROPOSAL
- HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA
- HR_MAINTAIN_PROPOSAL_API.UPDATE_SALARY_PROPOSAL
Try this out!!!
Posts
