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

Learn more
HCM Extract : Need help to Schedule with hourly frequency — 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

HCM Extract : Need help to Schedule with hourly frequency

Accepted answer
80
Views
8
Comments
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!