Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
Can you stop pay run from erroring when there is no GET_TABLE_VALUE return in the fast formula?
When using a GET_TABLE_VALUE function that doesn't find a value in a fast formula the pay run/quick pay will error.
The default message it produces is 'Data GET_TABLE_VALUE not found at line ....'
I would like to put some error handling in the fast formula so the pay run does not error and simply returns zero or nothing if it doesn't exist in the table values.
There doesn't appear to be a way to do this, as I'm unable to state something like 'IF GET_TABLE_VALUE(conditions) = 'no data found' THEN .....'.
Fast formula is quite restrictive in this manner and there is nothing to handle 'no data found' from using functions, but wondering if I'm missing a way to do this?