Compensation : Worksheet Columns Not Reflecting Correct Values For Hourly Employees (Doc ID 2226097.1)

Last updated on MARCH 26, 2017

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, .Manage Compensation
Issue:
When entering a value on the Compensation Worksheet for an Hourly Employee, the Proposed hourly or biweekly salary Salary and Proposed Annual Base are not updating.
The values that are entered are from the "Increase %" and "Merit Amount".

Expectation:
When a value is entered in the "Increase %" and "Merit Amount", it is expected that the the "Proposed Hourly or Biweekly Salary" and "Proposed Annual Base" fields should be updated per dynamic calculations.

Additional notes:
-"Proposed Hourly or Biweekly Salary" (Base Salary - New)
-"Proposed Annual Base" (Adjusted Salary - New)
-Tried changing the annualization factor to 2080 and frequency to hourly, this just caused issues for salary data
-Current setup is with annualization factor to 1 and frequency to salary, issue is on hourly employees.
-There are no fast formulas used on these columns. Only dynamic calculations
-If the user enters a value directly in "Proposed Hourly or Biweekly Salary", the hourly fields are updated correctly; however, this field is not editable/updateable in the 'Manage in Spreadsheet' and therefore is not a solution to meet business requirement.

Steps:
1. Compensation > Act as a Proxy Manager > Select Manager
2. Click on Mouser Annual Pay Review Plan 2017
3. Enter salary increase amount (Compensation Amount - Component 1)
Notice that The Base Salary - New and Adjusted Salary - New Column values are not updated based on the amount inputted in Compensation Amount - Component 1 column.

Business Impact:
Customer plans to go live with Annual Salary Reviews and needs to understand why calculations are not working as expected.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms