DAVE Function: Traverse previous time cards and get details (hours) in fast 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

DAVE Function: Traverse previous time cards and get details (hours) in fast formula

edited Jun 24, 2021 7:57AM in Workforce Management 1 comment

Content

I need to traverse previous time cards and get details (hours) in fast formula. I believe Oracle has introduced "DAVE" function to achieve this; am able to use this but I am unable to get the results. If anyone has a working example, please share with the group.

I am calling Function CALL_FORMULA('ORA_WFM_UTIL_DAVE_TIME_SCAN')..

Test case:

I have opened a SUBMITTED/APPROVED timecard and updated existing timecard day hours

e.g. For 07-Jun-2021 => 6 hrs (Original value) and have updated to 4 hrs (new value) 

My Fast formula got triggered and reviewed log messages. (attaching log message details)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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