Oracle Workforce Compensation: Default and Override Fast Formula Usage

Default and Override Fast Formula in Fusion Compensation

I was thinking about it for a long time and it seems that we don’t have a good repository of Fast formula’s on the web for Oracle Cloud. The Fast formula does not only help the technical developers implement solutions but it also helps a Functional consultant in understanding what is achievable in Oracle HCM Cloud. Some modules use Fast Formula’s more than others and Compensation is one module which utilizes the FF extensively. Today We will discuss Default and Override Fast Formula in Fusion Compensation and break it down to understand the inner workings and its final effect.

Following is the sample FF in its entirety. This FF is used to default values on the compensation worksheet when it’s not available on the worksheet out of the box.

/******************************************************************
FORMULA NAME: EWT_COMP_GET_FLSA_FF
FORMULA TYPE: Compensation Default and Override
DESCRIPTION : FF will get the FLSA code from the job of the employee

Name Date Description
-------------------------------------------------------------------
ERPWebTutor 01-JAN-2017 Initial Version

*****************************************************************/
DEFAULT FOR CMP_IV_PLAN_ID IS 0
DEFAULT FOR CMP_IV_PERIOD_ID IS 0
DEFAULT FOR CMP_IV_PLAN_START_DATE IS '1901/01/01 00:00:00' (date)
DEFAULT FOR CMP_IV_PLAN_END_DATE IS '1901/01/01 00:00:00' (date)
DEFAULT FOR PER_JOBS_LEG_EFF_HRX_US_JOBS_FLSA_STATUS IS 'X'
DEFAULT FOR PER_ASG_JOB_ID IS 0

INPUTS ARE CMP_IV_PLAN_ID (number), CMP_IV_PERIOD_ID (number),
CMP_IV_COMPONENT_ID (number), CMP_IV_ITEM_NAME (text), CMP_IV_PLAN_START_DATE (Date), CMP_IV_PLAN_END_DATE (Date)

CHANGE_CONTEXTS(EFFECTIVE_DATE = CMP_IV_PLAN_END_DATE)
/**************************************************************************
Get the FLSA code from the JOB
***************************************************************************/
IF PER_ASG_JOB_ID WAS DEFAULTED THEN
L_FLSA_CODE = 'None'
ELSE
L_FLSA_CODE = PER_JOBS_LEG_EFF_HRX_US_JOBS_FLSA_STATUS

L_DEFAULT_VALUE= L_FLSA_CODE
L_DATA_TYPE= 'CHAR'

RETURN L_DATA_TYPE, L_DEFAULT_VALUE

Let’s look at the following portion and let’s try to understand what is happening:

IF PER_ASG_JOB_ID WAS DEFAULTED THEN
L_FLSA_CODE = 'None'
ELSE
L_FLSA_CODE = PER_JOBS_LEG_EFF_HRX_US_JOBS_FLSA_STATUS

L_DEFAULT_VALUE= L_FLSA_CODE
L_DATA_TYPE= 'CHAR'

In the above portion of the code excerpt, the system checks if the job code for an employee is getting defaulted which in simple language means if its blank then set the FLSA code as blank. If not then use the DBI ‘PER_JOBS_LEG_EFF_HRX_US_JOBS_FLSA_STATUS’ to get the corresponding FLSA from employee’s jobcode and assign to the variable ‘L_FLSA_CODE’. Eventually, the variable is returned back.

Let’s look at the application now and understand how the FF is configured and its impact.

Log In as an administrator and click on the Compensation link:

Click on the ‘Manage Plan’ Link:

Navigate to ‘Configure Worksheet Display’ after choosing the workforce compensation plan you want to add the custom field

Click on the Component where the custom fields needs to be added

Click on ‘Details Table’, Look for the custom field where the FLSA status needs to populate and then click on ‘Properties’ icon

On the resulting pop-up window select ‘Default Values’ tab and then select the FF from the drop-down you just created. Click on ‘OK’, save everything and Run the ‘Full Refresh’ Process

Log in as a Manager and navigate to the Workforce compensation plan and you will see that all the employees in the plan now show the FLSA status

Similarly, any field on employment page or Person page can be displayed on the Workforce Compensation sheet for employees.

Next Fast Formula blog, we will talk about ‘Post Enrollment’ Fast formula in Benefits

For complete training on Fusion visit our Fusion HCM Courses

We also recommend you to visit Oracle Forums and explore Oracle Support to learn more scenarios and solutions.