My Oracle Support Banner

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

Last updated on MAY 03, 2018

Applies to:

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


On : version

Manage Compensation


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".

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.

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.