1. Implementing Compensation
  2. Default Value Properties of Worksheet Columns

Default Value Properties of Worksheet Columns

You can set default values for the column by selecting from the options available in the Default Values section of the Configure Column Properties page. The values populate the worksheet column when you run the Start Workforce Compensation Cycle process.

Here are properties that you can select from to set default values. Unless otherwise specified, after you set a property, the other properties disappear except Default value subject to refresh. You can see all properties again by clearing the current setting.

Property Description
Default Value Enter a specific number of series of characters that appears by default in the column.
Default and Override Formula

Replace any existing values, including blank, with default values returned by the specified Compensation Default and Override formula. For example, use a formula to get stored scores, rating, incentive plan amounts, target percentages, and special earning calculator values. Then use the formula results to set default values for the column.

To verify that the selected formula returns the expected results, run a test using a sample person record. Run the test by clicking the Test Condition and Column Results icon next to the formula.

  • If you get an incorrect formula, use the Fast Formulas task to correct your formula.
  • If you don't see an expected salary, make sure that the person's salary record exists as of the HR data extract date.
  • If a person unexpectedly has an Ineligible status, check the eligibility profile for their assignment.
Compensation Derived Factor Set default column values using a compensation derived factor. You create derived factors for compensation using the Derived Factors task in the Compensation work area.
Cross Reference Plan

Select the workforce compensation plan with the data you want to use as default values in this column. It can be the same plan.

After you select the plan, you need to specify which cycle and column to extract the default values from.
External Data Record Type

Specify whether the external data you're showing in the column is from a legacy application or third party.

After you select the record type, you need to select the external data column to get the default values from, for example, Column 16.

Reference

For descriptions of every worksheet column, see Workforce Compensation Worksheet Configuration Definition (document ID 1450891.1) on My Oracle Support (support.oracle.com). You can also see this information:

  • The navigation path for columns that map directly to a field in Oracle Fusion Global HR Cloud Service
  • If you can default column values using a plan cross-reference
  • If people can update the values in their plan budget and task worksheets.

Related Topics