Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
HSA Fast Formula Help — 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

HSA Fast Formula Help

Received Response
62
Views
10
Comments
edited Sep 18, 2020 10:56PM in Benefits 10 comments

Summary

HSA Fast Formula Help

Content

Hi,

We are getting an error message on our HSA Fast Formula.  I found a post on My Oracle Support and Oracle suggested "We recommend to use the array dbis instead of the functions.  In cases of term-rehire, global transfer etc, the assignment_id changes and the functions may not return correct values based on which date you look for benefits information, so we have provided person context based array dbis which do not get affected by assignment context. Please replace the function with array dbis in a phase wise manner."

I am not a programmer (the person who wrote the FF is no longer with us) and have no idea what this means so looking for any help to update the FF (line 38 is the error line - l_lf_evt_ocrd_dt = TO_DATE(l_lf_evt_ocrd_dt_char).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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