Any advice or recommendations expressed in this blog (or sites they link to) is our own experience and are not validated by Oracle

Sunday, October 7, 2007

Changing Salary Basis

An interesting scenario came in one of my current projects with my customer who are already using Oracle HRMS for past three years
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!!!