Validating Hourly Paid or Salaried Value and Job Exemption Status

Summary:

We have a requirement where Job Exemption Status and Hourly Paid or Salaried value should be aligned. If the Job Exemption is EXEMPT then Hourly Paid or Salaried should be Salaried and if Job Exemption is NONEXEMPT then Hourly Paid or Salaried should be Hourly. During a transaction like Hire and Employee, Promote, Transfer etc, when Manager changes the Job or Hourly Paid or Salaried value and if the new values are not aligned, the system should throw and error to correct the values. This is an approved Use Case.

The Object validation rule is working when the Job is changed from Exempt to Non-Exempt or vice-versa without changing the Hourly Paid or Salaried value. The system is throwing an error as expected. But in cases where Job is not changed but Hourly Paid or Salaried is changed from Hourly to Salaried or vice-versa, the rule is not triggering and is allowing the user to continue without any error.