You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GET_VALUE_SET does not return anything

edited Sep 5, 2020 12:33AM in Payroll and Global Payroll Interface (GPI) 4 comments

Summary

when calculating payroll for one elemet need to collect amounts of another element in past

Content

In the payroll fast formula, for one element, I have to get total amount of another element for the some past periods (max 2 years).

I have created Value set and calling it from another FF but result is 0. Where did I made mistake? I know that value set will return only one (first) value. BI report (Data Model) with same SQL works fine.

 

/* Formula Name : GET_PAST_ELEMENT_VALUES
   Formula Type : Oracle Payroll              
   Description  : Get element values for the past period
*/


/* Default for Inputs */

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!