Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Source Columns for Fast Formula
Summary
Need to find the source column to be used in Fast FormulaContent
Team,
I have created a Fast Formula to restrict the Benefit selection page give a warning message if the Voluntary Benefits have the coverage amount more than 5 times of the person Annual Salary.
I used the Data base column BEN_PEN_BNFT_AMT for validation purpose.
IF (BEN_PEN_BNFT_AMT > ( 5 * CMP_ASSIGNMENT_SALARY_AMOUNT * CMP_ASSIGNMENT_SALARY_ANNUALIZATION_FACTOR )) THEN
(SUCCESSFUL='N'
ERROR_MESSAGE = 'The coverage amount cannot be greater than 5*Annual Salary')
If i entered the amount more than the 5times of the person Annual Salary it didn't give a warning message. The plan got selected without any issues.
Tagged:
1