Not Able To Fetch The UDT Data In Oracle Payroll Fast Formula
(Doc ID 2577020.1)
Last updated on AUGUST 27, 2019
Applies to:Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document