Not Able To Fetch The UDT Data In Oracle Payroll Fast Formula (Doc ID 2577020.1)

Last updated on AUGUST 27, 2019

Applies to:

Goal

We are facing issue in fetching the UDT details in the Oracle Payroll Fast Formula.

Problem : UDT details are not getting fetched in Oracle Payroll FF

Steps followed :

Step 1: Manage User-Defined Table - Created a UDT of Unit type text with one single column of datatype text and multiple row.
Each Row w.r.t to Column have one value associated.
UDT Name : HOUSING_UDT_TEST
Column : RATE
Row : A to G (7 rows)

Setp 2: Manage Element - Create a Payroll Element name Housing Allowance which is recurring standard earning element.

Step 3: Manage Fast Formula - Search for 'Housing Allowance Earnings' fast formula and edit the calculation logic.
I am attaching the Fast Formula with the email - Highlighted part is edited.
We have tried fetching the details by using function GET_TABLE_VALUE

We were able to observe every time it fetched the default value and not the Amount according to Grade.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.