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 Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How do I generate a random number within a fast formula?

edited Jan 2, 2025 9:27PM in Benefits 3 comments

I am trying to generate random numbers to be used when logging Benefits related fast formulas, using ADD_RLOG (of course, this is applicable to non-Benefits related fast formulas as well).

L_FF_NAME = 'FORMULA_NAME'
L_FFS_ID = -1
L_RULE_ID = -1 /* I want this to be a random number */ R_LOG = ADD_RLOG(L_FFS_ID, L_RULE_ID, L_FF_NAME || ' | This is a log!')

From my understanding the L_RULE_ID could be leveraged to filter by an "instance/run". In theory, if I wanted to filter my report to capture just the logs associated with a single "instance/run" of an associated fast formula being triggered, having a unique identifier generated for each "instance/run" could allow me to filter by

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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