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 with Redwood for Oracle Cloud HCM   Begin Now

HCM Extract : Need help to Schedule with hourly frequency

edited Sep 25, 2018 2:22PM in HCM Integrations 8 comments

Summary

HCM Extract : Need help to Schedule with hourly frequency

Content

Hello Experts,

We need to schedule HCM Extracts to run every hour or less then that.

We tried Fast formula but that is not giving expected results.

Kindly provide some insights in this regard.

Kind Regards,

Mohan

 

Code Snippet

/*****************************************************************************
FORMULA NAME: Hourly Flow Schedule
FORMULA TYPE: Flow Schedule
DESCRIPTION: Formula to return a date time.
Returns NEXT_SCHEDULED_DATE;
Formula Results :
NEXT_SCHEDULED_DATE This will be a date time value with yyyy-MM-dd HH:mm:ss format.
*******************************************************************************/

/* Inputs */
INPUTS ARE SUBMISSION_DATE(DATE), SCHEDULED_DATE(DATE)

/* Calculations */
NEXT_SCHEDULED_DATE = ADD_DAYS(SCHEDULED_DATE,0.0208333)

/* Returns */
RETURN NEXT_SCHEDULED_DATE

/* End Formula Text */

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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