How to Validate Annual Tuition Reimbursement Limit (e.g., $2,000) Across Multiple Payments in Oracle
Summary:
Hello Everyone,
We have a custom element created for Tuition Reimbursement.
The element has an input value “Amount” with Create a Database Item enabled.
The business rule allows a maximum of $2,000 per employee per calendar year for tuition reimbursement. Employees can receive multiple payments during the year (for example: $1,000 in January, $1,000 in April, and $500 in August).
We want to validate each new entry so that the total reimbursement for the year (previously paid + current amount) does not exceed the $2,000 annual limit.
We tried using a Fast Formula for Element Input Validation, but we are not sure:
- How to fetch the
Tagged:
0