Social Icons

Wednesday, August 14, 2013

Writing Conditional Logic in Fast Formulas

Assignment
Write a simple Fast formula to update your Travel Payment formula to use the override travel rate, if it has been entered, and otherwise to use the global value.
Make sure you have read following articles on Fast Formulas.

1. Oracle HRMS Fast Formula – Tutorial
2. How to Define or Setup Global Value in HRMS
3. How to write simple Fast Formulas in Oracle HRMS

Writing Conditional Logic
Let us assume that the company has updated the Travel Payment element so that it now has a Pay Value and two input values: distance and override travel rate. Most employees receive the travel rate stored in the global value, but there is the discretion to override it with a special rate using the override travel rate input value.

1. Update your Travel Payment formula to use the override travel rate, if it has been entered, and otherwise to use the global value.

Hint: Use the WAS DEFAULTED condition.

Writing Conditional Logic
1. Navigate to the Formula window using your local Super HRMS Manager responsibility.
Total Compensation > Basic > Write Formulas
2. Set your effective date to 1 January 2000.
3. Query: XX_TRAVEL_PAYMENT, where xx is your group identifier.
4. Select the Edit button.
5. Add the conditional logic to your formula, and verify it.
6. When the formula verifies successfully, close the Edit Formula window.
7. Save your work.
8. Select Correction.

Your fast formula should be similar to the following:

DEFAULT FOR distance IS 0

DEFAULT FOR override_travel_rate IS 0
INPUTS ARE distance, override_travel_rate
IF override_travel_rate WAS DEFAULTED
THEN
travel_payment = distance * XX_COMPANY_TRAVEL_RATE
ELSE
travel_payment = distance * override_travel_rate
RETURN travel_payment


Please share your views about this Article.For more articles visit About ERP Oracle Apps

No comments :

Post a Comment

">