1. Administering Planning Modules
  2. Configuring Workforce
  3. Configuring Workforce
  4. Configuring Benefits, Taxes, and Additional Earnings
  5. Creating Custom Calculation Logic in a Component

Creating Custom Calculation Logic in a Component

Defining your own Workforce calculations in a custom component gives you great flexibility in applying conditional logic and specifying value drivers to calculations for additional earnings, benefits, or taxes.

For example, you could create a bonus calculation that applies to new hires who start in the first 6 months of a calendar year, but not for those who start in the last 6 months of the calendar year in their first year of hire. You can also select a value driver other than the predefined ones (for example, Flat Amount, Percentage of Salary, and so on). So, for example, you could base an additional earning such as commissions on a custom member that you create, for example, Revenue. To specify a member as the Value Type driver, you include it in the member formula for the custom component.

To customize logic in a custom component:

  1. In the Benefits and Taxes Wizard, on the Details page, edit an existing component, and for Component Type, select Custom.
  2. Continue setting up the component, optionally entering rates to be used in your custom logic.

    Include any thresholds in the member formula.

  3. Create a member formula for the OWP_Custom Expense member in the Property dimension:
    1. On the Home page, select Application, then Overview, and then Dimensions.
    2. Click the down arrow to the right of Cube, and then select OEP_WFP.
    3. Click Property, right-click in the Member Name column header, and then clear Default mode.
    4. Select the member OWP_Custom Expense, scroll right to the OEP_WFP Formula column, and then click in the intersection cell.
    5. In the upper left of the grid, click the Member Formula icon Member Formula icon.
    6. Enter the member formula.

Notes:

  • Before creating your own custom calculation logic, Oracle encourages you to first do due diligence in using the predefined calculations.
  • Evaluate the performance of your custom formula before taking the application into production.
  • To create and use multiple custom components, modify the OWP_Custom Expense member formula to accommodate each component’s custom logic. For example, use nested IF conditions for each custom component type.

Tip:

See the next topics for advice on customizing calculation logic and for several sample formulas.