Write a Fast Formula for Gratuity

You can write your own custom logic in the fast formula to calculate the gratuity payment amount.

You can either write your own custom logic in the fast formula to calculate the gratuity payment amount or enter the amount directly in the seeded element to override the amount calculated by the seeded element.

  1. Navigate to: Payroll > Fast Formulas.

  2. Click Create and enter the formula name: XXCUST_INDIA_GRATUITY_CALCULATION_FF

  3. Enter the Type: Oracle Payroll

  4. Enter additional details like Description, Legislative Data Group, Effective Start Date, and click Continue.

  5. Write the formula text in the Formula Text editor that opens.

  6. Click Submit.

  7. Compile the formula and verify that there are no errors.

/******************************************************************************
 $Header: 
 * Formula Name :  XXCUST_INDIA_GRATUITY_CALCULATION_FF
 * Description  :  Custom Gratuity Calculation for India localization
 *****************************************************************************/
 
/* The formula should have the below return values. 
l_gratuity_amount_payable
*/

l_gratuity_amount_payable = -1

/* Begin Custom logic - Add your custom logic here to set the value to the variable provided*/

l_gratuity_amount_payable = 100000

/*Custom logic End*/
	 
 return  /* Use the below return variables*/
       l_gratuity_amount_payable

Results:

The formula returns the value for Gratuity Amount Payable.