Oracle Fast Formula Tutorial-Defining User Tables and Accessing Table Values

You should now be familiar with Oracle Fast Formulas. In the following tutorial you will learn how to define user tables and access table values in Fast Formulas.

Assignment
Create a user table called xx Union Dues (where xx is your group identifier), using the following information.Enter 30 and 32 as Value against column dues.

Row1-Union A 30
Row2-Union B 32

Then write a formula called XX_UNION_DUES to get the appropriate deduction from the table, using the input Union.

Tasks to be carried out
Defining User Tables and Accessing Table Values

Imagine a company has defined a deduction for union dues. The deduction element has one input value (Union) for entering the name of the union to which the employee subscribes: Union A or Union B.

1.Create a user table called xx Union Dues (where xx is your group identifier), using the following information.

Union A 30
Union B 32

2.Then write a formula called XX_UNION_DUES to get the appropriate deduction from the table, using the input Union.

Solution - Defining User Tables and Accesing Table Values
Defining the Table Structure

1. Navigate to the Table Structure window using your local Super HRMS Manager responsibility.
• (N) Other Definitions > Table Structure
2. Set your effective date to 1 January 2000.
3. Enter xx Union Dues in the Name field, where xx is your group identifier.
4. Select Match in the Match Type field.
5. Select Number in the Key Units of Measure field.
6. Enter Union in the Row Title field.
7. Save your work.
8. Select the Columns button.
9. Enter Dues in the Name field of the Columns window.
10. Save your work.
11. Close the Column window.
12. Select the Rows button.
13. Enter 1 in the Sequence field and Union A in the Exact field of the Rows window.
14. Select New from the File menu.
15. Enter 2 in the Sequence field and Union B in the Exact field of the next row.
16. Save your work.
Entering Table Values
17. Navigate to the Table Values window using your local Super HRMS Manager responsibility.
• (N) Other Definitions > Table Values
18. Set your effective date to 1 January 2000.
19. Query: xx Union Dues, where xx is your group identifier.
20. In the Values region, select Union A in the Exact field and enter 30 in the Value field.
21. Tab to the next row and select Union B in the Exact field and enter 32 in the Value field.
22. Save your work.
Writing the Formula
23. Navigate to the Formula window using your localSuper HRMS Manager responsibility.
• (N) Total Compensation > Basic > Write Formulas
24. Set your effective date to 1 January 2000.
25. Enter the name XX_UNION_DUES, where xx is your group identifier.
26. Select Oracle Payroll in the Type field.
27. Select the Edit button.
28. Write your formula in the Edit Formula window, then select the Verify button.
29. When the formula verifies successfully, close the Edit Formula window.
30. Save your work.
Formula
Your formula should be similar to the following:
DEFAULT FOR union IS ' '
INPUTS ARE union(text)
deduction = 0
IF NOT union WAS DEFAULTED
THEN
deduction = TO_NUMBER(GET_TABLE_VALUE('xx_union_dues',
'dues', union))
RETURN deduction

Note: To complete the setup for the union dues deduction, you would:

• Define a formula processing rule to associate the formula with the Union Dues Deduction element
• Define a formula result rule to return the union_dues formula result to the element’s Pay Value

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