Value set Providing different results each time in Payroll Input Validation Formula — Cloud Customer Connect
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

Value set Providing different results each time in Payroll Input Validation Formula

edited Aug 8, 2025 9:39AM in Payroll and Global Payroll Interface (GPI) 1 comment

Summary:

I am using a fast formula (Payroll Input Validation) to call a Table Value set where a sql is ran to check the logged in user role.
I have attached the formula to a element at the element level as a Validation Formula.

It produces different results each time for the same user for the same element entry on the same date.

I tried hard coding a value in the Table Value set using a dual and it still produces varing results.

I have outputed the value set variable into the error message so I can see what is happening.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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