1. HCM Extracts
  2. How can I create a custom schedule for an HCM Extract?

How can I create a custom schedule for an HCM Extract?

Currently by default only daily, weekly, monthly options are provided for recursive scheduling.

If you want to create a custom schedule, you need to create a fast formula of type Flow Schedule and return when next flow has to be run, for example after 5 days.

To create a fast formula:

  1. Go to My Client Groups > Show More > Payroll > Fast Formulas.

  2. Click the Create icon.

  3. On the Create Fast Formulas window, in the Type field, select Flow Schedule.

  4. Write a formula to return the number of days. 

    /******************************************************************* FORMULA NAME: Daily Weekday Schedule FORMULA TYPE: Flow Schedule DESCRIPTION: Formula to return a date time. Returns NEXT_SCHEDULED_DATE; FORMULA RESULTS: NEXT_SCHEDULED_DATE This is a date time value with yyyy-MM-dd HH:mm:ss format. ********************************************************************/ /* Inputs */ INPUTS ARE SCHEDULED_DATE(DATE)  /* Calculations */ add = 1   /* Get day number for Friday. */ A_FRIDAY = TO_DATE('2012-01-06', 'YYYY-MM-DD') FRIDAY_NUMBER = TO_CHAR(A_FRIDAY, 'D')   day_number = to_char(SCHEDULED_DATE, 'D') if (day_number = FRIDAY_NUMBER) then add = 3 NEXT_SCHEDULED_DATE =ADD_DAYS(SCHEDULED_DATE, add)    /* Returns */ RETURN NEXT_SCHEDULED_DATE  /* End Formula Text */