Fast Formula to Validate User Tables in Oracle HRMS

In this practice you will learn how to write a fast formula that validates the user table. For this you need to first write a validation formula and then select the formula in the Columns window and test it by entering values outside the valid range in the Table Values window.

Writing Formulas to Validate User Tables
Write a validation formula that returns an error and a message if a user enters a value less than 10 or greater than 50 in the Dues column of your Union Dues user table. Name the formula XX_CHECK_UNION_DUES, where XX is your group identifier.

Select the formula in the Columns window, and test it by entering values outside the valid range in the Table Values window.

Writing Formulas to Validate User Tables
1. Navigate to the Formula window using your local Super HRMS Manager responsibility.
(N) Total Compensation > Basic > Write Formulas
2. Set your effective date to 1 January 2000.
3. Enter XX_CHECK_UNION_DUES in the Name field.
4. Select User Table Validation in the Type field.
5. Select the Edit button.
6. Write your formula, and verify it.
7. When the formula verifies successfully, close the Edit Formula window.
8. Save your work.

Formula
Your formula should be similar to the following:

INPUTS ARE entry_value(text)
IF TO_NUM(entry_value) <> 50
THEN
(formula_status = 'e'
formula_message = 'Union Dues must be between 10 and 50. Please re-enter.')
ELSE
formula_status = 's'
RETURN formula_status, formula_message

Selecting the Validation Formula in the Columns Window
9. Navigate to the Table Structure window using your local Super HRMS Manager responsibility.
(N) Other Definitions > Table Structure
10. Set your effective date to 1 January 2000.
11. Query: xx Union Dues in the Name field, where xx is your group identifier.
12. Select the Columns button.
13. Select your validation formula in the Formula field.
14. Save your work.

Testing Your Validation Formula
15. Navigate to the Table Values window using your local Super HRMS Manager responsibility.
(N) Other Definitions > Table Values
16. Set your effective date to 1 January 2000.
17. Query: xx Union Dues, where xx is your group identifier.
18. Select Query By Example - Run from the View menu.
19. In the Union A row of the Values region, enter 5 in the Value field. Tab to the next field. Your error message should be displayed.
20. Re-enter 30 and tab to the next row.
21. Select Correction.
22. Enter 60 in the Value field and tab to the next field. Again, your error message should be displayed.
23. Re-enter 32.
24. Select Correction.
25. Save your work.

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