My Oracle Support Banner

How to Pass Statement Periods from Total Compensation Statement into Compensation Item Rule Type Fast Formulas (Doc ID 419291.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Compensation Workbench - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

The information here pertains to the Formula Type: Compensation Item Rule Type

Reference: Note 218059.1 - Oracle FastFormula (FF) Reference Guide for Standard (OSB) and Advanced Benefits (OAB)


Question:

How does one pass the PERIOD_START_DATE (TEXT), PERIOD_END_DATE (TEXT) values into an external function
being called by their their fast formula without hard-coding any COMPENSATION_DATE date values or using global values for period begin and end dates?

Scenario:

Additional items available:
   - COMPENSATION_DATES1
   - COMPENSATION_DATES2
   - VALUE1
   - VALUE2

The user's external function has:
   - context assignment_id
   - 2 date input parameters:
        - p_period_begin_date
        - p_period_end date

These are currently populated by global values that are manually maintained.

User does not want to hard-code or set up global values to match the TCS setup
   - but does want the dates from the TCS setup to flow down to the fast formula and function.

How can we accomplish this?

Solution

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
Goal
Solution

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