Monday, 25 July 2022

HCM Fast Formula Creation Steps

Fast Formula is language to write formula using English word and basic mathematics functions to perform calculation or comparison.

 Section of Fast formula :

1. Alias Section (Optional)
2. Default Section
3. Inputs Section
4. Calculation Section
5. Comments
6. Return Section

Create sample Fast formula for absence.

Search for Fast formula task from setup and maintenance


 Create new Fast Formula

click on continue after entering details

 Write simple formula 

This will check if leave applied duration is greater than 5 then it will show error ‘DURATION IS GREATER THAN 5’
====================================
Code :
/**********************************
Formula Name : Annual Leave Fast Formula Demo
Formula Type : Global Absence Entry Validation 

***********************************/

INPUTS ARE

IV_START_DATE,
IV_END_DATE,
IV_TOTALDURATION

VALID='Y'
IF IV_TOTALDURATION> 5 THEN
(
  VALID ='N'
  ERROR_MESSAGE = 'DURATION IS GREATER THAN 5'
)

RETURN VALID, ERROR_MESSAGE
==================================

Save, Submit and then compile



Now attached Fast formula to Absence Type ‘Annual Leave AU’ as this absence type is assigned to employee

Add Fast Formula at validation formula


Save the changes

Now Login using employee and click on time and absence



Add Absence



Apply leave for period which total days will be greater than 5



After entering comments and reason submit absence


It will apply our fast formula while validating this absence records and show error


Now change to date range so total duration will become 5 and it will not satisfy fast formula condition


Submit absence and this time it allows to submit leave without any error




No comments:

Post a Comment

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...