My Oracle Support Banner

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 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.
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

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